Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)))
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |