Hi,

I'm new to MDX. I am trying to create a calculated member to give me a comparison with the same time period from the previous year.

I have been looking at the ParallelPeriods function but I am struggling to get the syntax correct.

I have a Time dimension (Year > Month > Date) and the measure I am want to use is called "Net Sales".

Can anybody help ?

Regards
Carl