SSAS MDX Previous Year to Date

Getting the YTD from a cube is a simple MDX formula either using the PeriodToDate function or using the YTD function.

One request you may get it to see the previous year to date. So if you are looking at March 21, 2011 year to date,  you want to see the year to date from March 21, 2010. This can be done by using the ParallelPeriod function.

Here is the Previous YTD calculation using adventure works.

(PARALLELPERIOD( 
[Due Date].[Date].[Calendar Year],
1,
[Due Date].[Date] ),
[Measures].[Sales Amount Reseller])