Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Average Time To Close

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)))

 

Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    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 

1 Reply

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    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