Add DAX preceding month date filter to a measure

[Anonymous]

Hi all,

I've had a hunt for a solution, though starting from a pretty limied level of knowledge which doesn't help...

I have the following measure applied to my data, which gives me the accompanying Table. I got these values even though I've only specified "FAI", so suspect that's not helping things. The '0' is added to ensure the table adds a 0 when there's a null value

To Date = CALCULATE(COUNTAX('IR H&S Incident Register','IR H&S Incident Register'[Classification]="FAI"))+0

What I'd like to do now is apply a date filter to this, to calculate incidents which have occured in the preceding month. I know I could do it with a visual level filter, but not in the same visual.

Hope you can help!

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To use this measure should work.

To Date =
VAR this_month =
    FORMAT ( TODAY (), "mm-yyyy" )
RETURN
    CALCULATE (
        COUNTAX (
            'IR H&S Incident Register',
            'IR H&S Incident Register'[Classification] = "FAI"
        ),
        FILTER (
            'IR H&S Incident Register',
            FORMAT ( 'IR H&S Incident Register'[date], "mm-yyyy" ) = thsi_month
        )
    ) + 0