cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SofG Frequent Visitor
Frequent Visitor

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 3
Icey Super Contributor
Super Contributor

Re: Employee turnover rolling 12

Hi @SofG ,

 

Maybe you can give me some sample data.

 

Best Regards,

Icey

SofG Frequent Visitor
Frequent Visitor

Re: Employee turnover rolling 12

Hi Icey,

 

Here's some sample data: Sample

 

Thank you!

 

Kind regards,

SofG

Icey Super Contributor
Super Contributor

Re: Employee turnover rolling 12

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.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)