Average Time To Close

[johnbradbury]

I'm trying to calculate the length of time a request was open based on the date it was logged and the date it was closed but I'm clearly getting something wrong in the calculations:

Time To Close = DATEDIFF('sheet1'[Logged Date],'sheet1'[Completed Date)))

[TomMartens · Accepted solution]

Hey,

this DAX-Statement

Duration = DATEDIFF('Table1'[StartdateTime],'Table1'[EnddateTime],SECOND)

returns

156600

using this input

StartdateTime         EnddateTime
2017-08-30 12:00	2017-09-01 07:30

Looking at your formula I'm wondering about the missing 3rd parameter (UNITS) of the DATEDIFF()-function and also the number of closing parantheses, and there is also closing bracket missing after [Completed Date]

Regards