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

[mespiritu]

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 and include NULLS (non-exited clients) 

[Anonymous · Accepted solution]

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.