Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Freeseman
Helper II
Helper II

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?

 

Freeseman_1-1667450345702.png

 

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@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

 

DataInsights_0-1667478880862.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Freeseman
Helper II
Helper II

solved it by changing my shift ident to whole number.

 

Thank you so much @DataInsights 

DataInsights
Super User
Super User

@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

 

DataInsights_0-1667478880862.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@DataInsights 

Thank you.

 

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

Freeseman_0-1667535171734.png

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.