Forum Discussion
nhodges
Helper I
Helper IFormula for Date Range filter
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"),"")
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 resultPlease 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.
1 Reply
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 resultPlease 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.