I want to create a calculated measure in SSAS using an MDX query. This measure should return the average amount within a period of a year and the same period last year. I've found out about the ParallelPeriod function but couldn't manage to use it.
My query should look like this
(
AGGREGATE(
{[TF_Product].[LastDayOfMonth]}
*{[TF_Product].[Category].&[Deposits]},
[Measures].[Montant]
)
+
AGGREGATE(
{ Get the date of the same period last year using parallelperiod}
*{[TF_Product].[Category].&[Deposits]},
[Measures].[Montant]
)
)/2
Thank you.
(1jan-4Apr2015 + 1jan-4Apr2016)/numdays
? – whytheq