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