% difference WK1 Mnth 2 and WK1 Mnth 1

Help
2010-04-22
2013-04-29
  • Advait Pandit
    Advait Pandit
    2010-04-22

    Hi,

    I know how to get a calculated member that calculates difference between 2 periods -
    "member . as '((., ..PrevMember) / (., ..CurrentMember))', FORMAT_STRING = "#,##0.00%"

    The above would help me calculate the difference between Month 1 and Month 2, Week 1 and Week 2 etc.
    However, I would like to create a calculated member that calculates a difference between Week 1 of Month 2 and Week 1 of Month 1.

    Thanks.

     
  • khandur
    khandur
    2010-04-22

    Hi!

    It´s simple.

    Measure performance in month 1: (., ...)

     
  • Julian Hyde
    Julian Hyde
    2010-04-22

    The ParallelPeriod MDX function exists for just this case.