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

koenmilt's avatar
koenmilt
Frequent Visitor
8 years ago

Hi v-yulgu-msft,

 

I'm sorry, I probably did not explain well enough. 

Indeed, it is reset. I am looking for a way in which the cumulative will NOT be reset in week 201704, even though the employee has a different cost center in that week.

 

The DAX which I described in my original post has the same behaviour as the one you suggest in your post.

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

Hi koenmilt,

 

Based on the sample in my above post, what is your desired result? Could you illustrate your requirement with examples? If possible, please post an image.

 

Regards,
Yuliana Gu