Forum Discussion

koenmilt's avatar
koenmilt
Frequent Visitor
8 years ago
Solved

Cumulative total ignoring certain table columns

I have the following situation:   I have a report in which i show the following: Employee Cost_center Function Year_Week Hours Spend Cumulative Hours spend   The cumulative Hours spend look...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi koenmilt,

     

    You could try  this:

    Cumulative Hours spend =
CALCULATE (
    SUM ( 'OVERUREN_WEEK'[Hours Spend] ),
    FILTER (
        ALLEXCEPT ( 'OVERUREN_WEEK', OVERUREN_WEEK[Employee] ),
        OVERUREN_WEEK[Year_Week] <= MAX ( OVERUREN_WEEK[Year_Week] )
    )
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi koenmilt,

 

You could try  this:

Cumulative Hours spend =
CALCULATE (
    SUM ( 'OVERUREN_WEEK'[Hours Spend] ),
    FILTER (
        ALLEXCEPT ( 'OVERUREN_WEEK', OVERUREN_WEEK[Employee] ),
        OVERUREN_WEEK[Year_Week] <= MAX ( OVERUREN_WEEK[Year_Week] )
    )
)

 

Best regards,

Yuliana Gu

koenmilt's avatar
koenmilt
Frequent Visitor
8 years ago

Yes! This works!

 

Thanks for helping me out.