Forum Discussion
Need help with headcount trend reporting
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.
Community ChampionCan you share the pbix using Google Drive or DropBox? can't download from your SharePoint...permissions error.
Give this a try...https://www.dropbox.com/s/tj0totccxwmqkuy/DummyHC_HR.pbix?dl=0
- littlemojopuppy
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!
