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 all - I'm trying to work out staff turnover figures, I need to knopw the number of employees who left in a certain time period.
I have the following DAX for a headcount of staff in a period set in a table
Solved! Go to Solution.
Hi @Anonymous
Based on your sample data I created disconnected time table with coulmns like quarter, year etc.
Then I created 3 measures:
Hi @Anonymous
Based on your sample data I created disconnected time table with coulmns like quarter, year etc.
Then I created 3 measures:
Thank you! By quater I mean Q1 2022 which would be January February March, Q2 2022 is April May June etc
Staff turnover is usuall done:
number of leavers / number of staff expressed as a percentage
ie 12 leavers from 240 staff is 5% turnover
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi - my data is a bit like this, some employees have end dates as they have leftm some do not as they are still employed
Employee | Status | Start Date | End Date |
000001 | Dormant | 27/09/2021 | 17/06/2022 |
000002 | Dormant | 10/05/2021 | 22/06/2022 |
000003 | Dormant | 11/10/2021 | 23/06/2022 |
000004 | Dormant | 15/02/2021 | 24/06/2022 |
000005 | Dormant | 03/03/2020 | 24/06/2022 |
000006 | Dormant | 11/04/2022 | 30/06/2022 |
000007 | Dormant | 19/01/2021 | 07/07/2022 |
000008 | Dormant | 03/09/2018 | 08/07/2022 |
000009 | Dormant | 23/04/2019 | 12/07/2022 |
000010 | Live | 24/05/2021 | |
000011 | Live | 11/02/2019 | |
000012 | Live | 14/02/2005 | |
000013 | Live | 20/04/2022 | |
000014 | Live | 01/01/2021 | |
000015 | Live | 12/04/2021 | |
000016 | Live | 25/03/2019 | |
000017 | Live | 16/09/2020 | |
000018 | Live | 07/06/2021 |
I'd like a table output that calculates the number of live employees each month, the number of leavers each month and then the difference between the 2 that I can change from monthly to quarterly to yearly
Turnover by Month | |||
Headcount | Leavers | Staff Turnover | |
Jan-21 | 100 | 6 | 6% |
Feb-21 | 105 | 4 | 4% |
Mar-21 | 101 | 8 | 8% |
Apr-21 | 98 | 2 | 2% |
May-21 | 104 | 4 | 4% |
Turnover by Quarter | |||
Headcount | Leavers | Staff Turnover | |
2021 Q1 | 104 | 18 | 17% |
2021 Q2 | 97 | 12 | 12% |
2021 Q3 | 100 | 11 | 11% |
Turnover by Year | |||
Headcount | Leavers | Staff Turnover | |
2021 | 105 | 35 | 33% |
2022 | 110 | 22 | 20% |
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |