max year rolling 12 months

[everest226]

I am using set Analysis trying to  get the data  of 12 months rolling but till last months only ,

my code

Count (DISTINCT {<Year={'$(=max(Year))'}, Month={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month)-1,'MM')))"}>} [user])

[sunny_talwar · Accepted solution]

Try this:

Count (DISTINCT {<Year, Month, MonthYear = {"$(='>=' & Date(AddMonths(Max(MonthYear), -12),'YYYY-MMM') & '<' & Date(Max(MonthYear),'YYYY-MMM'))"}>} [user])

[everest226]

Thanks Sunny