Forum Discussion
Annual Attrition% Calculation
Hi Anonymous ,
I expanded each item of HeadCount and got the following results.
[Total Count - ALL] should be 1935. An extra line was added in Excel.
Another problem lies in [Total Join-After], I want to know what is the logic of this.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
The total count in excel, it is taking header as well, hence we used -1 to get 1935.
Total Join After is the count of new joiners after the month given on the left side of the table.
Hope this clarified your query.
Regards,
Pavan
Hi Anonymous ,
Then there is no need to subtract one in pbix, because it doesn't count the header.
It should be like this
Headcount = [Total Count - ALL] - [Total Join - After] - ([Total Left before] - [Total Left])MAX('Date'[Date]) in Total Join-After returns the largest day of the currently selected month. as the picture shows. So remove the equal sign in Total Join-After.
Total Join - After = CALCULATE ( [Count], FILTER ( ALL ( 'Date' ), 'Date'[Date] > MAX('Date'[Date])))The number of newly-added employees after December 31, 2020 should be 0, so I think it may be that the formula in your Excel is wrong. 186 should be the number of new employees joining after November 30, 2020.
Hope my explanation can help you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I would like to know how can we achieve the annualised attrition % as mentioned in the excel with the existing data.
Regards,
Pavan