Dynamic Timestamp Difference

You could create a calculated column like

Time difference =
IF (
    'Table'[Item] = "B"
        && 'Table'[Type] = "X",
    VAR CurrentTime = 'Table'[Time]
    VAR NextAvailableTime =
        MINX (
            FILTER (
                ALL ( 'Table'[Item], 'Table'[Type], 'Table'[Time] ),
                'Table'[Item] = "C"
                    && 'Table'[Type] = "X"
                    && 'Table'[Time] > CurrentTime
            ),
            'Table'[Time]
        )
    VAR Result =
        DATEDIFF ( CurrentTime, NextAvailableTime, MINUTE )
    RETURN
        Result
)

Hi Taro_Gulat ,

I think you can also try measure to achieve your goal.

MEASURE =
VAR _VirtualTable =
    ADDCOLUMNS (
        FILTER ( 'Table', 'Table'[Item] = "B" && 'Table'[Type] = "X" ),
        "DateDiff",
            VAR _CurrentDateTime = [Date]
            VAR _MINDatetime =
                MINX (
                    FILTER (
                        ALL ( 'Table' ),
                        'Table'[Item] = "C"
                            && 'Table'[Type] = "X"
                            && 'Table'[Date] > _CurrentDateTime
                    ),
                    'Table'[Date]
                )
            RETURN
                DATEDIFF ( [Date], _MINDatetime, MINUTE )
    )
RETURN
    AVERAGEX ( _VirtualTable, [DateDiff] )

Result is as below.

Best Regards,
Rico Zhou

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