Forum Discussion

Helper II

3 years ago

Solved

Dump time difference between 2 shifts

Hello, I hope you can help as i am battling to find away to calculate the time difference beween 2 dumps over 2 shifts. I will explain: I need a calculation that takes the latest time of shi...

3 years ago

Try this measure:

Minutes Diff = 
VAR vLastDumpShift1 =
    CALCULATE (
        MAX ( ShiftData[DUMP_END_TIMESTAMP] ),
        ShiftData[DUMP_END_SHIFT_IDENT] = 1
    )
VAR vFirstDumpShift2 =
    CALCULATE (
        MIN ( ShiftData[DUMP_END_TIMESTAMP] ),
        ShiftData[DUMP_END_SHIFT_IDENT] = 2
    )
VAR vResult =
    DATEDIFF ( vLastDumpShift1, vFirstDumpShift2, MINUTE )
RETURN
    vResult

DataInsights

Super User

3 years ago

Freeseman,

Try this measure:

Minutes Diff = 
VAR vLastDumpShift1 =
    CALCULATE (
        MAX ( ShiftData[DUMP_END_TIMESTAMP] ),
        ShiftData[DUMP_END_SHIFT_IDENT] = 1
    )
VAR vFirstDumpShift2 =
    CALCULATE (
        MIN ( ShiftData[DUMP_END_TIMESTAMP] ),
        ShiftData[DUMP_END_SHIFT_IDENT] = 2
    )
VAR vResult =
    DATEDIFF ( vLastDumpShift1, vFirstDumpShift2, MINUTE )
RETURN
    vResult