Forum Discussion
Employee turnover rolling 12
Hi,
I am trying to calcualte employee turnover rolling 12 and employee turnover last quarter.
I have used following caluculation for staff turnover. Does anyone know how I can adjust it/what I can add to create employee turnover rolling 12 and employee turnover last quarter?
Thanks!
Count Started =
CALCULATE(
DISTINCTCOUNT('People Data'[Person CC Role]);
FILTER (
'People Data';
'People Data'[Correct Start date]>=MIN('Dynamic Calendar Table'[Date])
&& 'People Data'[Correct Start date]<=MAX( ('Dynamic Calendar Table'[Date])
)))
Count Ended =
CALCULATE(
DISTINCTCOUNT('People Data'[Person CC Role]);
FILTER (
'People Data';
'People Data'[Correct end date]>=MIN('Dynamic Calendar Table'[Date])
&& 'People Data'[Correct end date]<=MAX( ('Dynamic Calendar Table'[Date])
)))
MIN ENDED STARTED = MIN([Count Ended];[Count Started])
Contracts Start =
CALCULATE (
DISTINCTCOUNT('People Data'[Person CC Role]);
FILTER (
'People Data';
'People Data'[Correct Start date]<MIN('Dynamic Calendar Table'[year])
&& 'People Data'[Correct end date]>=MIN( ('Dynamic Calendar Table'[year])
)))
Avg Contracts = ([Contracts Start]+[Contracts])/2
Contracts =
CALCULATE (
DISTINCTCOUNT ('People Data'[Person CC Role 2]);
FILTER(
'People Data';
'People Data'[column Correct Start date]<=MAX('Dynamic Calendar Table'[Date])
&& OR('People Data'[column Correct end date]>MAX( ('Dynamic Calendar Table'[Date]));ISBLANK('People Data'[Employment end date]))
))Staff Turnover Total = [MIN ENDED STARTED]/[Avg Contracts]
3 Replies
Hi SofG ,
As I tested, the data structure I got was not complete. Maybe you can refer to these articles or videos:
1. DAX for Power BI: 12 Month Rolling Average
2. Employee Turnover Dashboard – Power BI for HR
3. Rolling Employee Turnover by Fiscal Year
4. Calculating Employee Attrition Rate with DAX – Part 1
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
