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,
I have some standard Headcount data (including Unique Position ID, Start and Leave Dates). I have imported the dataset into PowerBI and, to get a timeline view of the number of people in the business over time, I created an 'expand date' function that generates dates for people between the start and leave date - i.e. for that position ID, if they stayed for a year, there would be 365 entries as the person was there from say 01/03/2019 to 01/03/2020.
I want to, now, be able to show the numbers of starters (and leavers) per month. Essentially, want to show how many came into the business per month - so rather than what I have above (going from 220 to 222 for instance), I want this graph to show what this was due to (e.g. 4 starters and 2 leavers in that particular month).
Any assistance/advice would be greatly appreciated!
Hi
Thanks all!
Links above all show great possible ways to slove this knid of problems.
If anyone has difficulties implementing this, please ask your question here.
Best Regards
Maggie
@tobiasmcbride - Seems like a time intervals situation. Thinking Open Tickets might help although it could be simpler than that, just calculate the number of Start or End dates between the MIN and the MAX dates in context.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
@tobiasmcbride
Refer to this link, it is resolving similar scenarios else you can still adapt it.
https://community.powerbi.com/t5/Desktop/Calculate-Current-Employee-Count-based-on-Joined-and-Leave-...
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |