Forum Discussion
Solved
Calculate difference between two date/time values
Hi, I have two columns with time stamps. first i create a measure for echa column thats calculates the average time: Measure = FORMAT(AVERAGE(AQZ_TRAVEL_MON[Tijd_Begin]);"HH:MM: SS") Now ...
Try this:
measure differents = FORMAT('Table'[measure 1] - Table[measure 2];"HH:MM: SS")
Why are you using SUMX to find the difference?
datadiff and datebetween don't work, so I tried sumx. which would you recommend?
Try this:
measure differents = FORMAT('Table'[measure 1] - Table[measure 2];"HH:MM: SS")