Forum Discussion
Solved
Calculating time difference does not deliver the expected result
Dear community, I need to calculate the time difference between a column named "time_val" (formatted as date/time) as provided in the image below and "1/1/1970 0:00:00". The result should be prov...
Don't use the .date extension on the field. That invokes the hidden auto time intelligence date field. Try this.
duration = DATEDIFF(DateValue("1/1/1970"),SomeTable[time_val],HOUR)
Don't use the .date extension on the field. That invokes the hidden auto time intelligence date field. Try this.
duration = DATEDIFF(DateValue("1/1/1970"),SomeTable[time_val],HOUR)
