Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 aggr...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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