Running Total

[Gowtham_Ganesan]

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 the start date to the end date.
Please assist in determining the running total for AER.
Thank you in advance.

[amitchandak · Accepted solution]

@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.