DAX Help

[GMireles]

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))

[GilbertQ · Accepted solution]

Hi @GMireles 

This might help Solved: Calculating Turnover Rate in DAX ( But: Using Ave... - Microsoft Fabric Community

[GMireles]

This is great thank you!