Forum Discussion
Post Patronrunning totals
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
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])))
4 Replies
- amitchandak
Super User
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])))
MarcUrdangthanks SO much .. .have accepted as a solution
have a super weekend
- 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
