Forum Discussion
Running total for predicted hours
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!
Mappe , are you looking for allocation or distribution?
3 Replies
- amitchandak
Super User
Mappe , are you looking for allocation or distribution?
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.
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!
