Forum Discussion
calculate average headcount & attrition
Hi Guys,
I'm trying to calculate average headcount per month, it's part of a formula to calculate attrition.
the end result is I would like to see is a line chart showing average headcount for each month.
For attrition I would like to see a line chart showing Attrition in % for each month.
I have been trying to get this working for a while. unfortunately no luck for me.
If someone is up for the challange I have uploaded PBIX file with dummy data here.
attrition formula I'm trying to get to is this: (YTD Unmanaged Leavers / FY month we are in * 12) / YTD AVR Headcount
Thanks to all who has helped me in the past
Anonymous , refer if the attached file and measure in the video can help
Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA
1 Reply
- amitchandak
Super User
Anonymous , refer if the attached file and measure in the video can help
Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA