Forum Discussion
MarcUrdang
Post Patron
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 o...
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])))
