Forum Discussion

Wirestat's avatar
Wirestat
Frequent Visitor
3 years ago

Find Order Duration based on Start Stop time

Hello, please can you help to find order duration based on starting and finishing time example like in column duration.  Order id From To Duration 0 23:00 23:03   1306993 23:03 23:0...
duration
from
start
stop
to
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Wirestat 
Please try 

Duration (Minutes) =
SUMX (
    VALUES ( 'Table'[Order ID] ),
    VAR CurrentIDTable =
        CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Order ID] ) )
    VAR FirstStart =
        MINX ( CurrentIDTable, 'Table'[From] )
    VAR LastEnd =
        MAXX ( CurrentIDTable, 'Table'[To] )
    RETURN
        DATEDIFF ( FirstStart, LastEnd, MINUTE )
)