Calculating time between separate rows based on another column

Hi thehalfboy ,

Please follow these steps:

1.        add new column

Column = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
        'Table',
        'Table'[Requisition Number] = EARLIER ( 'Table'[Requisition Number] )
    )
)

the final "SUBMIT" and the final "APPROVE" = 
VAR _1 =
    CALCULATE (
        MAX ( 'Table'[Action Date] ),
        FILTER (
            'Table',
            'Table'[Action Code] = "APPROVE"
                && 'Table'[Column] = EARLIER ( 'Table'[Column] )
        )
    )
VAR _2 =
    CALCULATE (
        MAX ( 'Table'[Action Date] ),
        FILTER (
            'Table',
            'Table'[Action Code] = "SUBMIT"
                && 'Table'[Column] = EARLIER ( 'Table'[Column] )
        )
    )
RETURN
    DATEDIFF ( _2, _1, HOUR )

2.    sort APPROVE

sort = 
RANKX (
    FILTER (
        'Table',
        'Table'[Action Code] = "APPROVE"
            && 'Table'[Column] = EARLIER ( 'Table'[Column] )
    ),
    'Table'[Action Date],
    ,
    DESC
)

3.     the penultimate "APPROVE" and the final "APPROVE"

the penultimate "APPROVE" and the final "APPROVE" 1 = 
VAR _actDate =
    CALCULATE (
        MAX ( 'Table'[Action Date] ),
        FILTER (
            'Table',
            'Table'[sort] = 1
                && 'Table'[Column] = SELECTEDVALUE ( 'Table'[Column] )
        )
    )
VAR _actDate2 =
    CALCULATE (
        MAX ( 'Table'[Action Date] ),
        FILTER (
            'Table',
            'Table'[sort] = 2
                && 'Table'[Column] = SELECTEDVALUE ( 'Table'[Column] )
        )
    )
RETURN
    DATEDIFF ( _actDate2, _actDate, MINUTE )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}