Home Forums Data Warehousing Analysis Services MDX ParallelPeriod Function - HELP RE: MDX ParallelPeriod Function - HELP
Jonathan Mallia
SSCertifiable
Points: 5192
More actions
May 27, 2013 at 3:21 am
#1618718
Hi,
You should try something on the lines of:
SUM([SalesAmount]) - SUM((ParallelPeriod([Calendar].[DateAAAAMMGG].[Year], 1, [Calendar].[DateAAAAMMGG].CURRENTMEMBER),[SalesAmount]))
Let us know how it goes...
Jon