Forum Discussion
Summing up cumulative hours
Hello,
I am exporting project information from dynamics in which I have users log in their time per project task. What I would like is to see the total estimated project hours vs. the actual aggregated sum of the logged hours.
What I would like to do is to pick the month of October (for example) and see the sum of hours for the project. If I click on December, it should change accordingly. What I managed so far is to simply see the sum of hours per month, and not for the total project. My table is as following:
| Project | Project task | Date | Duration (task hours) | Estimated hours project) |
| a | x | Oct 3, 2019 | 1 | 75 |
| b | y | Oct 3, 2019 | 8 | 75 |
| c | z | Nov 1, 2019 | 8 | 75 |
Thanks in advance,
Ori
4 Replies
- amitchandak
Super User
For estimated hours use Sum of MAx. Please refer to Sum of Averages
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601 
v-frfei-msftCommunity Support
Hi Anonymous ,
Does that meet your requirement?
total = VAR dur = SUM ( 'Table'[Duration (task hours)] ) RETURN IF ( dur = BLANK (), BLANK (), CALCULATE ( SUM ( 'Table'[Estimated hours project)] ), ALLSELECTED ( 'Table' ) ) )Hi Frank.
Been away from this and only picking it back up now. I managed to attach a sample of my table here and I hope it will be more clear now. I have multiple lines for each task and different dates. What you suggested did not work (unfortunately). Again, what I am trying to achieve is to see the cumulative total for each date point (so December will show me the entire year up to December and January will include December as well).
Thanks in advance,
Ori
