Any idea on how to make this work?
tuple ( parallelPeriod ([Sales].[Sales Periods].[By Period].[Year],1,[P_Period3]),[ACTUAL],[Column1 Rate Type] )?
It does not like the parallelPeriod function in the tuple. no syntax error, but returns zero.
This is ok...
tuple ( [P_Period3],[ACTUAL],[Column1 Rate Type] )
you'll need tell it firmly that even if we do not like something but if it is our job, it should do it. we are all professionals here .... ;D just kidding!!!!
what is the value of P_Period3 that works? can you try other functions that is supposed to return the expected value like lag. use constant parameters if you have to just to see if it works.
example instead of:
parallelPeriod ([Year],1,[Jan 2015])
try
lag ([Jan 2015],12)