Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |