Forum Discussion

sureshcu's avatar
sureshcu
Helper I
9 years ago

Moving sum

Hi,   I have data from 2005 to till data. I want to show last twelve months rolling total wherein previous years total to be added.the following measure is showing only month on month total. but it...
Need Help
TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

I have to admit, that do not fully understand your requirement so for this reasom I'm not sure if this is what you are looking for.

Here you will find an example.

 

On the report page you will find an example for y rolling sum, that is calculated with this measure:

Rolling Sum last 12 Months = 
var endDate = CALCULATE(MAX('Calendar'[Date]))
var startDate = MAXX(DATEADD('Calendar'[Date], -12, MONTH),'Calendar'[Date])
return
CALCULATE(
	SUM('FactWithDates'[Amount])
	,DATESBETWEEN('Calendar'[Date],startDate,endDate)
)

Please be aware, that the report shows Month whereas the Measure considers day, so for this reason it is not valid to add up the depicted Months ;-)

 

Hope this helps

Regards