DATEDIFF Using Time

[bhmiller89]

I have two columns: "Open Date/Time" and "Resolved Date/Time." They are both Date/Time data types

Not every item has a resolved date/time, but all of them have open date/time.

I need to calculation the total time in hours between "Open Date/Time" and "Resolved Date/Time."

I'm not able to get it to work using DATEDIFF

[Sean · Accepted solution]

Minutes = 
SWITCH (
    TRUE (),
    'Table'[start_date] < 'Table'[end_date], DATEDIFF ( 'Table'[start_date], 'Table'[end_date], MINUTE ),
    'Table'[start_date] > 'Table'[end_date], DATEDIFF ( 'Table'[end_date], 'Table'[start_date], MINUTE ) * -1,
    0
)

This will take care of start times that are after end times which cause an error

Also as you can see blanks would not cause errors and how you hanlde those is up to you 

[dedelman_clng]

Are you getting a specific error message when creating the column/measure, or just not seeing the data you are expecting?