Power Bi time differences

Hi Syndicate_Admin ,

Suppose we have a table:

Please try this:

Avg = 
VAR _hours =
    SUMX (
        SUMMARIZE (
            'Table',
            'Table'[Material],
            'Table'[Date],
            "HOUR",
                DATEDIFF (
                    'Table'[Date],
                    CALCULATE (
                        MIN ( 'Table'[Date] ),
                        FILTER (
                            ALL ( 'Table' ),
                            'Table'[Date] > EARLIER ( 'Table'[Date] )
                                && 'Table'[Material] = EARLIER ( 'Table'[Material] )
                        )
                    ),
                    DAY
                )
        ),
        [HOUR]
    )
VAR _times =
    COUNTROWS ( 'Table' ) - 1
VAR _result =
    DIVIDE(_hours,_times)
RETURN
    _result

result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum