Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Reader,
I/m facing some difficulties with Datediff. Please see below. This is part of querri where I'm substracting two dates. So here the result should be something like 11.xx minutes. For most data the result is ok, but when the day changes i get wrong answers. See 2d picture. What is get is 'day (24*60)-11 minutes, = -1429 minutes
Im stuck, how can i solve this?
reg martijn
Solved! Go to Solution.
hi, @martijnth
It seems that [time produced] is a date-time column then you just change the format of it.
So you need to use this way as below:
Use TIME Function to add a new time column as below:
Time1 = TIME(HOUR(Table1[time produced]),MINUTE(Table1[time produced]),SECOND(Table1[time produced]))
Result:
Best Regards,
Lin
hi, @martijnth
It seems that [time produced] is a date-time column then you just change the format of it.
So you need to use this way as below:
Use TIME Function to add a new time column as below:
Time1 = TIME(HOUR(Table1[time produced]),MINUTE(Table1[time produced]),SECOND(Table1[time produced]))
Result:
Best Regards,
Lin
thanks, solved
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |