Forum Discussion
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...
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
