Employee turnover rolling 12

[SofG]

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]

[Icey]

Hi @SofG ,

Maybe you can give me some sample data.

Best Regards,

Icey

[SofG]

Hi Icey,

Here's some sample data: Sample

Thank you!

Kind regards,

SofG

[Icey]

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.