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.
Hello,
I've looking through the forum and I can't find the answer, so I'm asking my particular case.
I have a simple table with 2 columns: Name, ReportedDate.
I need to make a measurement with the average time (in hours) between all the rows. For example:
Test 1 - 01/22/2018 10:00:00 AM
Test 2 - 01/22/2018 10:30:00 AM
Test 3 - 01/22/2018 11:00:00 AM
With this data, I have a half hour on average.
How can I do this?
Solved! Go to Solution.
See this article:
You will want the column that uses the EARLIER function. At that point you can create another column that calculates the difference in hours or minutes and then you should be good to go.
See this article:
You will want the column that uses the EARLIER function. At that point you can create another column that calculates the difference in hours or minutes and then you should be good to go.
Thanks for your help.
I'm trying to reproduce it in my case.
I'm having another error with this part: DATEDIFF([ResolvedDate],NOW(),SECOND)
ResolvedDate column has this data.
ResolvedDate
1/22/2018 6:07:13 PM |
1/22/2018 6:11:13 PM |
1/23/2018 4:11:30 PM |
1/22/2018 6:12:01 PM |
1/22/2018 6:11:44 PM |
and the error message is this: In DATEDIFF function, the start date cannot be greater than the end date. How this is possible?
Yeah, DATEDIFF can be a pain:
DATEDIFF(NOW(),[ResolvedDate],SECOND)
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |