running totals

[MarcUrdang]

I am able to achieve this as long as the running total is in a column ... however I would like to see the running totals as follows and hoping someone can advise the correct calculation if there is one.

                      Jan       Feb    Mar   Apr   May   Jun   Jul   Aug   Sep   Oct   Nov   Dec

Year: 2021 

Value             10         10      10     10     10     10      10    10     10     10     10      10        

**bleep** total      10         20      30     40     50      60     70     80    90      100   110    120

Year: 2022

Value             10         10      10     10     10     10      10    10     10     10     10      10        

**bleep** total      130        140   150    160    170 etc etc 

[amitchandak · Accepted solution]

@MarcUrdang , what is your source table structure , usually running total with Date or sortable month year (YYYYMM)  you can get like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

or

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

[MarcUrdang]

Hi Amit .. that works perfectly ... just one more question ... now that the numbers are in a matrix .. I need another calc that works out the % diff ie ... not sure if i need to post another request for this ?

             Jan

2021     

     Val     25

   % dif     

2022

     Val     40

   % diff   60

[MarcUrdang]

thanks SO much .. .have accepted as a solution

have a super weekend