Forum Discussion
Solved
Cumulative Total by Year
I have a table with a cumulative total which works well, but it continues to add year on year, instead of resetting each year. What I currently have is this: Running Total column = CALCULAT...
Make sure that you have a date table linked to your sales table, and use columns from the date table in all your visuals.
Either mark the date table as a date table, or use the new calendar options to create a calendar.
You can then write a measure like
Running Total = CALCULATE ( SUM ( 'Sales'[Sales Amount Actual] ), DATESYTD ( 'Date'[Date] ) )
Make sure that you have a date table linked to your sales table, and use columns from the date table in all your visuals.
Either mark the date table as a date table, or use the new calendar options to create a calendar.
You can then write a measure like
Running Total =
CALCULATE ( SUM ( 'Sales'[Sales Amount Actual] ), DATESYTD ( 'Date'[Date] ) )