Forum Discussion

Freeseman's avatar
Freeseman
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 shift 1 "Dump_End_Timestamp" and the earliest time of shift 2 "Dump_End_Timestamp" to give me its difference in Minutes. Keeping in mind by selecting the dump location.

 

Is this possible?

 

 

Need Help
Show and Tell
  • DataInsights's avatar
    DataInsights
    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

     

     

3 Replies

  • DataInsights's avatar
    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

     

     

    • Freeseman's avatar
      Freeseman
      Helper II
      3 years ago

      DataInsights 

      Thank you.

       

      This looks like it could be the answer. I however get this message:

       

      Any idea how i should format the date to be able to do the calculation?