Forum Discussion

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

    thanks SO much .. .have accepted as a solution

    have a super weekend

  • MarcUrdang's avatar
    MarcUrdang
    Post Patron
    4 years ago

    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