Help with date time DAX calculations

DAX DAX Calculations
1

Hi All,

I have 2 columns of dates and time (created date, created time, and Resolved date, and resolved time). Occassionally, a ticket will not be resolved until the next calendar day.

For Example:
Created date Time: 28/03/2018 12:22PM
Resolved date Time: 29/03/2018 08:31AM
How do I calculate the total time the ticket took to resolved in hours and in minutes?

I need to calculate the average resolution time for each ticket.

Thanks,
Liz…

2

@Chukliz,

Have you taken a look at this post? Very similar issue.

Calculating working hours between 2 timestamps - #2 by JarrettM

  • Brian