Forum Discussion
Solved
Need help with headcount trend reporting
Hi, I have created a report that shows headcount over time using measures, but when I adjust my date slicer, it recalculates the headcount for only the selected time period in the slicer (per measur...
Hi!
Your headcount at any point in time is the sum of everyone hired, separated, rehired and re-separated. Your headcount calculation was only looking at people with one of those things happening during the selected date range. I added measures for running totals for each and changed the headcount calc to use those running totals. You can download the pbix here.
I also simplified your measures for hired, separated, rehired and re-separated...they were unnecessarily complex. You should also check them for accuracy.
Thank you so much for the quick help and simplification of my measures!
littlemojopuppy
Community Champion
Community ChampionYou're welcome! Glad I could help! 🙂