Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

cumulative table

Hi looking to find an easy way to turn the table below into a cumulative table

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

v-lili6-msft
7 years ago
hi, Anonymous

You could just use formula like below to create a cumulative measure

Cumulative = CALCULATE ( expression, FILTER ( ALL ( YourTable ), YourTable[Bucket] <= MAX ( YourTable[Bucket] ) ) )

here are related blogs for you refer to:

https://www.daxpatterns.com/cumulative-total/

https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/

Best Regards,

Lin

3 Replies

v-lili6-msft
Community Support
7 years ago
hi, Anonymous

You could just use formula like below to create a cumulative measure

Cumulative = CALCULATE ( expression, FILTER ( ALL ( YourTable ), YourTable[Bucket] <= MAX ( YourTable[Bucket] ) ) )

here are related blogs for you refer to:

https://www.daxpatterns.com/cumulative-total/

https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/

Best Regards,

Lin
Anonymous
Not applicable
7 years ago
i am looking to find a way to make this table cumulative so on the left side we have number of users and the bottom we have number of days. I want a way to say 0 = 22% rather than 1=3% it should be 1=25%
- AUaero
  Responsive Resident
  7 years ago
  Take a look at the cumulative total pattern.
  https://www.daxpatterns.com/cumulative-total/
  
  Cumulative Quantity := CALCULATE ( SUM ( Transactions[Quantity] ), FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ) )