Forum Discussion
cumulative table
Hi looking to find an easy way to turn the table below into a cumulative table
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
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
Responsive ResidentTake 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] )
)
)