Forum Discussion

mespiritu's avatar
mespiritu
Icon for Helper I rankHelper I
2 years ago
Solved

DAX formula for specific date range and also include (NULLS)

Can someone helps assist a DAX calculation -    I'm trying to set a date range i.e. (06/01/2023 - May 30, 2024)    and also want to create another DAX calculation that includes date range above a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mespiritu ,

    I create a table as you mentioned.

    Then I create a calculated column and here is the DAX code.

    Column = 
IF (
    (
        'Table'[Date] >= DATE ( 2023, 6, 1 )
            && 'Table'[Date] <= DATE ( 2024, 5, 30 )
    )
        && ISBLANK ( 'Table'[ClientStatus] ),
    "Done",
    "Nulls"
)

     

     

     

    Best Regards

    Yilong Zhou

    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
2 years ago

Hi mespiritu ,

I create a table as you mentioned.

Then I create a calculated column and here is the DAX code.

Column = 
IF (
    (
        'Table'[Date] >= DATE ( 2023, 6, 1 )
            && 'Table'[Date] <= DATE ( 2024, 5, 30 )
    )
        && ISBLANK ( 'Table'[ClientStatus] ),
    "Done",
    "Nulls"
)

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.