Issue with Rolling 12 Months

[sudhakar_b]

I'm basically trying to show the sum of a measure for rolling 12 months. For some reason the set analysis is not evaluating properly.

When i select apr 2012, the graph should display from may 2011 to apr 2012

Any help is appreciated. i'm attaching the sample file for the same.

[Jason_Michaelides · Accepted solution]

Your issue is your inconsistent date formatting.  Set analysis respects date formatting so try this:

Sum({<MonthYear={">$(=Date(AddMonths(Max(MonthYear),-12),'MMM-YYYY'))<=$(=Date(AddMonths(Max(MonthYear),0),'MMM-YYYY'))"}>} Attritiioncount)

Also, for some reason you can't have a space either side of the red bit!

Hope this helps,

Jason

[sudhakar_b]

Hi Jason, Thanks... worked like a charm.