Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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% |
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |