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

• casagrandi

  Old Hand

  Points: 351

  More actions

  April 14, 2023 at 8:40 am

  #4173906

  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 ?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 15, 2023 at 9:10 am

  #4174412

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

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