Hi There,
I am trying to build the below report:
Unfortunately without a success.
Could you please guide me to make it working correctly?
I tried with many custom measures but the recent one is as follows (for the specific Transation Status):
Sum(
Filter(
Descendants([Time].CurrentHierarchyMember,[Time].CurrentHierarchy.Levels("Day")),
DateBetween(
[Time].CurrentHierarchyMember.StartDate,
([Transition Status].[In Design],[Issue Type].[Epic],[Measures].[Transition to status first date]),
([Transition Status].[In Design],[Issue Type].[Epic],[Measures].[Transition from status last date])
)
),
([Measures].[Hours spent],[Logged by].CurrentMember)
)
Thanks in advance for your support.