Hello everyone,
Has anyone figured out a great way to calculate/visualize rolling 12 turnover rates? I have a file that contains all the dates (hire and terminations). I also have the dates listed of the 12 months in question 2/28/2023 - 2/28/2024. Below is the formula I am trying to use, but would what I am not sure about is the "Total Turnover Measure." Would I have to manually calculate this and then insert into the equation?
I am trying to find a solution that won't need a lot of constant updating! Any help would be appreciated 🙂
Rolling 12 Months Turnover Rate =
VAR NumOfMonths = 12
VAR LastCurrentDate = MAX('YourDateTable'[Date])
VAR Period = DATESINPERIOD('YourDateTable'[Date], LastCurrentDate, -NumOfMonths, MONTH)
VAR TotalTurnover = [Total Turnover] -- actual turnover measure
VAR RollingTurnover = CALCULATE(SUM(TotalTurnover), Period)
RETURN
DIVIDE(RollingTurnover, COUNTROWS(Period))
