Forum Discussion
Solved
Need help in calculating headcount
Hey There , I need some help to calculate the future Headcount based on the actual headcount ,future joiners and furture endings .. So, I have 3 table , Actual Headcount till Mar , Future starts...
Hi,
I have solved a similar problem in the attached files. Please review my solution and adapt it to your needs.
PhilipTreacy
Super User
Super User
You haven't provided any data so I'm guessing how your tables look and the data contained in them. But using the sample data I created in the PBIX file linked above, you can get what you want with these measures
Prev HC = CALCULATE(SUM('Actual Headcount'[Actual HC]), PREVIOUSMONTH('Actual Headcount'[Date]))
Future HC = [Prev HC] + SUM('Future Starts'[Future Starts]) - SUM('Future Endings'[Future Endings])
Regards
Phil
Thank you for your response PhilipTreacy
I should have explained the situtaion in details ;
So when we are calulating headcount for May, calculation should be Aprils new new headcount(1743 in this case)+ May's Joiners- May's endings..
| Date | Actual HC | Future Starts | Future Endings | Future HC | Calulation |
| Dec-23 | 2136 | 2136 | |||
| Jan-24 | 2019 | 2019 | |||
| Feb-24 | 1964 | 1964 | |||
| Mar-24 | 1672 | 1672 | |||
| Apr-24 | 213 | 138 | 1747 | =E5+C6-D6 | |
| May-24 | 25 | 247 | 1525 | =E6+C7-D7 | |
| Jun-24 | 313 | 1212 | =E7+C8-D8 | ||
| Jul-24 | 157 | 1055 | =E8+C9-D9 | ||
| Aug-24 | |||||
| Sep-24 | |||||
| Oct-24 | |||||
| Nov-24 | |||||
| Dec-24 |