MDX - 12 trailing months
Posted on 2014-02-06
I need an MDX WHERE clause that will give me the selected date and the 11 preceding. For example, select January 2014 and get Feb 2013 - Jan 2014.
Is there a DateDiff or something that I can use in the WHERE clause in MDX for this kind of query?
I have found LastPeriods:
WHERE (LastPeriods(12.0, [Dim Date.MonthNum].))
But ... nothing there specifies the year.