Forum Discussion

Gowtham_Ganesan's avatar
Gowtham_Ganesan
New Member
3 years ago
Solved

Running Total

Hi,  I need to calculate the running total for a column called AER. I have shared screenshot of  a graph and a table. In the graph, instead of the running total for the month, it shows the AER from ...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Gowtham_Ganesan , With help from the date table we create a running total like

     

     

     

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

     

    or

     

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

     

    Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

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

Gowtham_Ganesan , With help from the date table we create a running total like

 

 

 

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

 

or

 

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

 

Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.