Min of LastNonEmpty values

• Donpi

  SSC Veteran

  Points: 252

  More actions

  March 30, 2021 at 9:35 am

  #3863543

  I everybody,

  I'am currently fighting with Mdx in a cube about the active directory.

  In simple words the cube is :

  • a dimension accounts
  • a dimension groups
  • a dimension dates
  • a measure last non empty with the days id of the last password set.

  Everything works fine except that I don't whant the last non empty values to be sumed but I want the min a values of the last non empty values .

  Here is two attached examples.

  Can anyone help ?

  • This topic was modified 3 years, 8 months ago by  Donpi.
  • This topic was modified 3 years, 8 months ago by  Donpi.

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  March 31, 2021 at 10:10 am

  #3863928

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

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