Forum Discussion
Headcount and Turnover based on Dataset
- 4 years ago
Anonymous , Refer to the blog and attached file on this topic after signature
Anonymous , Refer to the blog and attached file on this topic after signature
Hi
Thank you so much for this, I've got the headcount working after tweaking the formula. Added the brackets in Red.
From my underestanding and please correct me if I'm wrong, the original formula misses out a few lines as the || (OR) is expressed with the &&(And) rather from the Employee Start Date, so the added brackets will give me a more accurate number.
Current Employees = CALCULATE(COUNTx(FILTER(Employee,(Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date])) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))
Thank you again, I just need to calculate the Turnover Rate now. I need the turnover rate per month as well as the overall rate from June 21- June 22, are you able to help me with that?
Turnover Rate for Month = (
"Terminations within Month"
/
("Headcount From Pervious Month End" + "Headcount of Current Month End") /2)
)
x 100
Turnover Rate for Period = (
"Terminations all period"
/
("Headcount from the beginning of period [June-21]"+"Headcount at the end of the period [June-21]")/2)
)
x 100
I have no idea what these actually calculate, can you explain sorry?
- Last Period Active Employees: Last Period Employees
- Period over Period Change %: Employee Change%
Thank you
*edited, corrected turnover rate formula