cumulative table

[Anonymous]

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

[Anonymous]

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]

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] )
    )
)

[v-lili6-msft · Accepted solution]

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