First Transition in First day of Current Month

Questions & Answers
2

Hi,

The following formula finds the name of the status which had the earliest transition on the first day of the month:

Filter(
  [Transition Status].[Transition Status].Members,
  (([Measures].[Transition to status first timestamp],
  [Time].[Day].Datemember('first day of month'))
  =
  ([Measures].[Transition to status first timestamp],
   [Transition Status].DefaultMember,
   [Time].[Day].Datemember('first day of month')
   )
   )
).Item(0).GetCaption

If there will be no transition on that day, the result shows #null

Kindly,
Janis, eazyBI support

1 Like