Forum Discussion

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
3 years ago

Forecast Remaining Capacity for Succeeding Years

Hello Everyone. Seeking for your help in my bar chart. I wish to see the remaining capacity left for 12 months of the current year and for the next 12 months of another year.   Here's the outcome I...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi third_hicana ,
it looks as if you have to calculate the average of the maximum capacity and subtract the sum of the project assigned capacities from it. 
A measure like this would do it:

RemainingCapacityByMonth =
SUMX (
    VALUES ( Table2[Month] ),
    CALCULATE ( AVERAGE ( Table2[Maximum Capacity] ) )
        - CALCULATE ( SUM ( Table2[Project Capacity Assigned] ) )
)

Make sure to replace the Month-column by a reference to the month column of your calendar table.
Also, you might have to add the employee id to the iterated rows to create the correct result if no employee is selected on the visual.


  • third_hicana's avatar
    third_hicana
    Icon for Helper IV rankHelper IV
    3 years ago

    Hi ImkeF  I have already ID number for employees. What I need to achieve is a montly check and balance of how many days available left to each employee and not the average. I cannot also subtract the sum of assigned capacities because some of the projects end in different months. So my desire outcome is a monthly check of days left.