how to get previous value in a fact table for a measure in mdx

  • Hello Guys!

    I want to write an mdx query with a calculated Measure. Here is my fact table:


    How to implement a mesaure with the rule below :

    If CurrentAtt != PreviousAtt then PreviousValue

    else CurrentValue


    I mean by previous the value in the previous period.

    Thank you so much!

    any suggestion please ?

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply