Check Date From today to last 30 days

[SS_1122]

Hey All, 

Thank you in advance for helping me out in this. I have a data where there is a column for continuous dates over last 10 months, I have to create a measure where I need to check whether the last 30 dates from today is present or not , if it is it then "No failures" if it doesn't thenn count the number of dates that are missing.

Kind Regards.

[ToddChitt]

DAX Measure:

My Count of last 30 days = CALCULATE ( DISTINCTCOUNT('Table'[Dates] ) , 'Table'[Dates] > DATEADD( DAY, -30, TODAY () )

Note this is 'airware', may not be totally accurate.

You may also need a second filter in the CALCULATE function of: 'Table'[Dates] < TODAY()

[SS_1122]

This gives an error saying 'DATEADD' has been used as a tbale filter expression.

I tried something like this :

Last 30 days = CALCULATE ( DISTINCTCOUNT('Sheet1'[Dates] ) , 'Sheet1'[Dates] > DATEADD(Sheet1[Dates], -30,  DAY() )
The data is only this 

[v-rzhou-msft · Accepted solution]

Hi @SS_1122 ,

You can try this measure to achieve your goal. My Sample has data from 2022/10/01 to 2022/12/12, today is 2022/11/14. Last 30 dates is from 2022/11/15 to 2022/12/14. So the measure result should return 2.

Last 30 dates from today is present or not =
VAR _Today =
    TODAY ()
VAR _Last30Days =
    CALENDAR ( _Today + 1, _Today + 30 )
VAR _ADDFlag =
    ADDCOLUMNS (
        _Last30Days,
        "Flag", IF ( [Date] IN VALUES ( 'Table'[Date] ), 1, 0 )
    )
VAR _Count =
    COUNTX ( FILTER ( _ADDFlag, [Flag] = 0 ), [Date] )
RETURN
    IF ( _Count = 0, "No failures", _Count )

Result is as below.

Best Regards,
Rico Zhou

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