Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
4 years ago
Solved

running 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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
4 years ago

thanks SO much .. .have accepted as a solution

have a super weekend