How do I calculate average Response Time and Resolution Time ?

[Rck7]

Hello Friends,

I have an Issue Table, with IssueID, IssueDate, StartDate , Resolved Date as Columns. I would like to calculate the a) the average First response time(in hours), b) average re-solution time(in hours) for the dates selected on my slicer.

Attached is a glimpse of my Issue Table, where Issue Date - is the Issue created date, Start Date- is the date an Issue has been taken/first responded by a user, Resolved Date- is the date where an Issue is closed/re-solved by the User. I have tried several measures but unable to find the apprpriate solution in hours. Kindly, help me with your suggestions. 



I would like to get my Result like below:


Any help would be very much appreciated.
Thank you.     

[zenmemo · Accepted solution]

Hi @Rck7, is this what you're looking for?

Average Response Time = DATEDIFF(StartDate,ResolvedDate,HOUR)