Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@TapZxK , refer if the attached file and measure in the video can help
Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA
@TapZxK , refer if the attached file and measure in the video can help
Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |