Forum Discussion
Anonymous
7 years agoNot applicable
cumulative table
Hi looking to find an easy way to turn the table below into a cumulative table
- 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
v-lili6-msft
Community Support
7 years agohi, 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