Date ranges Custom Columns in Power Query- Give a certain amount of payment if enrolled within two dates.

Table.AddColumn(#"Grouped rows", "ITSPaymentFinal", each if [HHIDEarliestEntry] <= #date(2024, 12, 15) then 225 else if [HHIDEarliestEntry] >= #date(2024, 12, 16) and [HHIDEarliestEntry] <= #date(2024, 12, 31)then 187.5 else if [HHIDEarliestEntry] >= #date(2025, 1, 1) and [HHIDEarliestEntry] <= #date(2025, 1, 15) then 150 else if [HHIDEarliestEntry] >= #date(2025, 1, 16) and [HHIDEarliestEntry] <= #date(2025, 1, 31) then 112.5 else if [HHIDEarliestEntry] >= #date(2025, 2, 1) and [HHIDEarliestEntry] <= #date(2025, 2, 15) then 75 else 0)

Need to save this because it took a long time to figure out