Summing up cumulative hours

[Anonymous]

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

[v-frfei-msft]

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' ) )
    )

[Anonymous]

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

[amitchandak]

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Amit,

Thanks for the quick reply. The link you are referring to is talking about averages. I am not looking for the average sum but for the total amount of hours logged in the project. Or did I misunderstood the solution that is provided there?

Ori