Date Difference of current record and its relative record using MDX

• LearnTSQL

  SSC-Addicted

  Points: 428

  More actions

  August 2, 2023 at 3:59 pm

  #4251162

  Dear All,

  I have a some rows where it points to another row in same table based on RelativeId column value. I need to find the difference of these two records date values using MDX.

  for ex.  sample table structure with some values

  ID - HasRelative - Date - RelativeId

  1 - False - 2023-01-01 - NULL

  2 - True - 2023-08-01 - 1

  Here record 2 has a relative record 1. The output should be difference of Date values between 2 records which are mapped with RelativeId.

  Thank you very much

  • This topic was modified 9 months, 1 week ago by  LearnTSQL.
  • This topic was modified 9 months, 1 week ago by  LearnTSQL.

• August 2, 2023 at 6:06 pm

  This was removed by the editor as SPAM

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  August 3, 2023 at 4:10 pm

  #4252072

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

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