cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oreo101
Regular Visitor

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.

 

Untitled1.png

 
 

 

 

 

 

 

 

 

 

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:

 

ProjectProject taskDateDuration (task hours)Estimated hours project)
axOct 3, 2019175
byOct 3, 2019875
czNov 1, 2019875

 

Thanks in advance,

Ori

4 REPLIES 4
Super User IV
Super User IV

Re: Summing up cumulative hours

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





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


oreo101
Regular Visitor

Re: Summing up cumulative hours

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

Community Support
Community Support

Re: Summing up cumulative hours

Hi @oreo101 ,

 

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

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
oreo101
Regular Visitor

Re: Summing up cumulative hours

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,

OriUntitled.png

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors