Average time between events

Hi Kohrinn 

You can create several calculated columns as follow.

Datediff = 
VAR _lastdate =
    CALCULATE (
        MAX ( CIP_CIPStationConcentrates[ActionDate] ),
        FILTER (
            CIP_CIPStationConcentrates,
            [ActionID] = EARLIER ( CIP_CIPStationConcentrates[ActionID] )
                && [TankID] = EARLIER ( CIP_CIPStationConcentrates[TankID] )
                && [CIP Station] = EARLIER ( CIP_CIPStationConcentrates[CIP Station] )
                && [ActionDate] < EARLIER ( CIP_CIPStationConcentrates[ActionDate] )
        )
    )
RETURN
    DATEDIFF ( _lastdate, [ActionDate], DAY )

Time = 
AVERAGEX (
    FILTER (
        CIP_CIPStationConcentrates,
        [ActionID] = EARLIER ( CIP_CIPStationConcentrates[ActionID] )
            && [TankID] = EARLIER ( CIP_CIPStationConcentrates[TankID] )
            && [CIP Station] = EARLIER ( CIP_CIPStationConcentrates[CIP Station] )
    ),
    [Datediff]
)

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax

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