This project has moved and is read-only. For the latest updates, please go here.

Period over Period MDX Code

Oct 9, 2014 at 7:48 PM
Edited Oct 9, 2014 at 7: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?
Oct 9, 2014 at 10:13 PM
Maybe:

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