Attrition Rate for last 12 months

[Anonymous]

Hi experts,

I'm trying to calculate the attrition rate for the last 12 month period.

So far I have the following table:

To calculate the YTD i used:

Overall Attrition Rate YTD =

TOTALYTD([Overall Attrition Rate], 'dimDate'[Date])

How can I filter that so it calculates for the last 12 months?

Best,

Soph

[Anonymous · Accepted solution]

Nailed it!

Rolling 12M Overall Attrition Rate =

VAR __NrOfRollingMonths = 12

VAR __CurrentDate = MAX ( 'dimDate'[Date] )

VAR __RollingMonths =

    FILTER (

        ALL ( 'dimDate' ),

        'dimDate'[Date] > EDATE ( __CurrentDate, - __NrOfRollingMonths )

            && 'dimDate'[Date] <= __CurrentDate

    )

RETURN

    CALCULATE ( [Overall Attrition Rate], __RollingMonths )