Formula for Date Range filter

[nhodges]

Hi trying to make a date filter so that it will show "Iteration 1" if the date range is from 03/23/2023 to 06/23/2023. And will show "Iteration 2" for anything after 06/23/2023. My formula is not working. 

Iteration Launch = IF('12_PM_REPORT_PBI'[EVENT_DATE]>=03/23/2023,IF('12_PM_REPORT_PBI'[EVENT_DATE]<=06/23/2023,"Iteration 1", "Iteration 2"),"")

[Anonymous · Accepted solution]

Hi @nhodges ,

Please create a measure with below dax formula:

Measure =
VAR min_date =
    MIN ( 'Table'[Date] )
VAR max_date =
    MAX ( 'Table'[Date] )
VAR result =
    IF (
        min_date >= DATE ( 2023, 03, 23 )
            && max_date <= DATE ( 2023, 06, 23 ),
        "Iteration 1",
        "Iteration 2"
    )
RETURN
    result

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.