Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |