average waiting time

Hi Anonymous ,

 

Here I create a sample to have a test.

Measure:

Avg Datediff =
VAR _SUMMAIRZE =
    SUMMARIZE (
        'Table',
        'Table'[Category],
        "DateDiff",
            VAR _Anchroge =
                CALCULATE ( MAX ( 'Table'[Entry Date] ), 'Table'[Attribute] = "Anchroge" )
            VAR _Terminal =
                CALCULATE ( MAX ( 'Table'[Entry Date] ), 'Table'[Attribute] = "Terminal" )
            RETURN
                DATEDIFF ( _Anchroge, _Terminal, DAY )
    )
RETURN
    AVERAGEX ( _SUMMAIRZE, [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.