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.
Hello,
I hope you can help me.
I am trying to calculate the attrition rate of Employees. The formula that I have to use is:
Ave# of Employees = Beginning Headcount + Ending Headcount / 2
Attrition Rate (%) = Total# of Termination / Ave# of Employees * 100
And below is my dataset:
Personnel Number | Employee Name | Employment Start Date | Last Date Worked |
0001 | Smith, John | 02/01/2008 | 30/11/2017 |
0002 | Smith, Jane | 15/08/2016 | 25/05/2017 |
0003 | Doe, John | 27/02/2017 | 01/03/2017 |
0004 | Doe, Jane | 22/03/2018 | 10/05/2018 |
0005 | Jackson, Mark | 05/06/2018 | 09/10/2018 |
0006 | Jackson, Mich | 09/07/2018 | 20/09/2018 |
0012 | Johnson, Kelly | 23/07/2018 | 29/11/2018 |
0013 | Johnson, Jessica | 14/11/2016 | 31/08/2018 |
0014 | 10/05/2015 | 04/03/2017 | |
0015 | 14/03/2011 | 29/03/2018 | |
0016 | 29/11/2018 | ||
0017 | 05/12/2018 | ||
0018 | 19/09/2016 | ||
0019 | 07/12/2018 | ||
0020 | 07/01/2019 | ||
0021 | 09/01/2019 |
Any updates on how to calculate the attrition percentage?
Hi @PatrickLamoste,
I have a little confused about your scenario.
I am trying to calculate the attrition rate of Employees. The formula that I have to use is:
Ave# of Employees = Beginning Headcount + Ending Headcount / 2
Attrition Rate (%) = Total# of Termination / Ave# of Employees * 100
What is the Beginning Headcount, the ending Head count and the Total# of Termination?
If it is convenient, could you share your desired output based on the data sample you shared so that I can understand your scenario better and get the solution quickly.
Best Regards,
Cherry
The beginning headcount is the number of employees for my case it's April 1 as it is our FY start date. The end headcount is the total number of employees left at the end of the period March 31. Get their sum and then get the average.
Termination is the number of employees who left the organization.
FInally, divide the number of termination with the average employees to get the attrition rate.
The output that I need is to get the attrition rate either monthly or annually.
Let me know if you need more information.
Thank you!
Please guide, how to calculate average number of employees in a spesific month ?
i have calculater in my dashboard and all related data but im stuck in it.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |