Forum Discussion
Forecast Remaining Capacity for Succeeding Years
Hey third_hicana ,
I can't follow your explanation. Looking at the data inside the pbix file I do not see the data you are talking about. Please check the data and explain the expected result based on the data you provide in the pbix and Excel. Make sure that both files contain the same data.
I see 4 projects for June 2022, none of these projects is A or B.
Regards,
Tom
Kindly use this data. Basically my goal is to evaluate how many days are left to each employee on a monthly basis based on the capacities required assigned to him/her.
So there is only one maximum capacity per month which is 5 days. If there are two assigned capacities, these should be subtracted only to 5 days in that particular month. The more you assigned capacity days in a particular month, the 5 days maximum continues to decrease.
The month in X axis should be months of the calendar and not from the month column of the assignment table. Employee A has a maximum of 5 days capacity. If there is no project and assigned capacity, it should show 5 days in the bar of the months of no assignment,.
Link:
https://1drv.ms/x/s!AoVsZM9hRj8DgZQyht21Hp9v6vxHlg?e=eFXTVc
As you can see for June and July, it should be -2.5 days. If you subtract the capacities assigned from two projects of Employee A for the month of June and July to 5, it should be negative.
