Forum Discussion

gkakun's avatar
gkakun
Helper III
4 years ago
Solved

Event duration

Hi all,   I have a question, i have this table, and im trying to know how long spesific escalation was in each event type. For example- escalation 168 opened-->moved to on hold-->reopened---> moved...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi gkakun ,

     

    You are correct, I have made the contrary logic how long does it take to get from the previous status.

     

    Replace the calculations by:

    Duration = 
DATEDIFF (
    'Table'[Date Time],
    CALCULATE (
        MIN ( 'Table'[Date Time] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[EscalationID] = EARLIER ( 'Table'[EscalationID] )
                && 'Table'[Date Time] > EARLIER ( 'Table'[Date Time] )
        )
    ),
    DAY
) + 1

     

    try if  #"Added Index"[EscalationID]{[Index] + 1} = [EscalationID] then  Duration.Days( ( #"Added Index"[Date Time]{[Index] + 1}) - [Date Time]) + 1 else null otherwise null

     

     

     

gkakun's avatar
gkakun
Helper III
4 years ago

Thanks a lot! its working.