Days between two specific statuses

[gerda.grantina]

Hello @Jovanka_Jovicic
Please check this solution on how to count days between two status transitions:

Avg days between two statuses

@joejames Try this code: CASE WHEN ( [Measures].[Transitions to status], [Transition Status].[Waiting for Production] ) > 0 THEN AVG( Filter( Descendants([Issue].CurrentMember, [Issue].[Issue]), ( [Measures].[Transitions to status], [Transition Status].[Waiting for Production] ) > 0 ), DateDiffDays( ( [Measures].[Transition to status first date], [Transition Status].[In Progress], [Time].CurrentHierarchy.DefaultMember…

best,
Gerda