Forum Discussion

nhodges's avatar
nhodges
Icon for Helper I rankHelper I
3 years ago
Solved

Formula 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 wor...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.