How to make table display yearly amount ?

[Anonymous]

Hi All

I like to modify the below 6 month rolling to yearly rolling , i try to change the 24 to 12 , it does not work .

6 Month new =

var _max = maxx(ALLSELECTED('Date Auto'), 'Date Auto'[Date])

var _min = date(YEAR(_max),MONTH(_max)-24,1)

return

Calculate([Sales], FILTER('Date', 'Date'[Date] <=_max && 'Date'[Date] >=_min))

[amitchandak]

@Anonymous , yes, it should. create a visual with month year near to it and check

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can update the _min part.

var _min = edate(_max,-12)