Measure to show Transition Author and Transition Date

[zane.baranovska]

@prakash_ps, you might want to use the dimension “Transition Status” with the measure “Transition to status last date” to get the latest transition to specified status.

For example:

([Measures].[Transition to status last date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember)

There are Community posted on related topic:

Transition from status Last Date gives me all the transition date, no matter the status

You would like to use brackets around the measure and transition status to make it work as a tuple. The tuple, in this case, will give you a date of the last transition to the specified status. You might as well consider including time default member there: ([Measures].[Transition from status last date], [Transition Status].[Status A], [Time].CurrentHierarchy.DefaultMember) If there are no brackets, eazyBI will use measure [Measures].[Transition from status last date] only. eazyBI uses the f…