Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Rolling Total not calculating correctly

Hello all, 

 

I have an issue where I am trying to calculate the rolling sum for monthly actuals

 

 

Actuals Month running total in FY Date = 
CALCULATE(
	SUM('iFiscal Unpivoted'[Actuals Month]),
	FILTER(
		ALLSELECTED('iFiscal Unpivoted'[FY Date]),
		ISONORAFTER('iFiscal Unpivoted'[FY Date], MAX('iFiscal Unpivoted'[FY Date]), DESC)
	)
)

 

 

 The following screenshot illustrates my issue.

Here is what the data looks like in my model. Please note that some Actuals have repeated dates as they correspond with different expenses.

Can someone please help me find the right configuration to correctly calculate the rolling sum?

4 Replies