Forum Discussion

aflora's avatar
aflora
Frequent Visitor
5 years ago
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...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    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.

littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

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.

aflora's avatar
aflora
Frequent Visitor
5 years ago

Thank you so much for the quick help and simplification of my measures!

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    5 years ago

    You're welcome!  Glad I could help!  ğŸ™‚