Forum Discussion

Regular Visitor

4 years ago

Solved

Monthly Cumulative total

Hi, I'm trying to create a report that shows the current months total to date (From the beginning of the month to the selected date). That's easy, but I then also want to show what previous months c...

Tips and Tricks

Trosa_220568
4 years ago
I have ended up using this:

Rolling Total = IF(ISBLANK('Sales'[Total Sales]),BLANK(),TOTALMTD('Sales'[Total Sales],'Calendar'[Date]))

It gives me a running total for each month so that an easy comparison can be made.

Community Champion

4 years ago

Hey Trosa_220568 try:

All_Selected_Until_One_Month_Back = 
VAR _current_date = 'Date'[Date]
RETURN
CALCULATE(
	[Sales],
	ALLSELECTED('Date'),
	'Date'[Date] <= DATEADD(_current_date,-1,MONTH)
)