Running total for predicted hours

[Mappe]

Hello community,
Im new to power Bi, and struggling with this one:

Im trying to get predicted hours to line chart in timeframe. My goal is to show running total on how many hours in different weeks needs to be done to fullfill expected hour use. Those predicted hours needs to be calculated together for phase start between phase end dates, not for different phases separately.

I have different table where i can get information how many hours has been made for different worknumbers, and that one i have sorted out already. Running totals for that works fine and is shown in line chart.

Would be great to have those predicted hours in that line chart also.
Relationships:

Thanks for any advice!

[amitchandak · Accepted solution]

@Mappe , are you looking for allocation or distribution?

example :
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[Mappe]

Thanks @amitchandak!

That worked, but there is something wrong. It shows lesser hours than it should. But i check if ican figure that one out myself.

[Mappe]

Hi,

@amitchandak just to let you know, i found that problem.

I had same values in predicted hours, but another phase. It didnt count those. So i identified worknmb and phase in new column. Now it works like a charm.

Thank you again for your advice!