Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |