Hello every one I have an MDX calculation for Issue Status for First day of current month. I need to have new Measure which is shows First transition issue Status in first day of current month.
This is my current MDX :
CACHE ( CASE WHEN
not IsEmpty([Issue].CurrentHierarchyMember.Get(‘Status updated at’))
[Transition Status].[Transition Status].Members,
[Measures].[Issues history] )>0).item(0).getCaption