Period over Period MDX Code

Oct 9, 2014 at 6:48 PM
Edited Oct 9, 2014 at 6:52 PM
I'm trying to write an MDX expression to show the variance of this year versus last year where the years are in the columns, but have been unsuccessful. Does anyone know how to write the expression?
Coordinator
Oct 9, 2014 at 9:13 PM
Maybe:

Name: My Measure Variance to Prior Year
Expression:
[Measures].[My Measure] - ([Measures].[My Measure],[Date].[Year].CurrentMember.PrevMember)