Timedifference represents the time between StationaryObject A and C for example. So in this case Timedifference would be 00:10:00. the expected outcome would be the distance traveled by the moving object between those points
The column "Time" we see here is a calculated column which displays an average of when the MovingObject was at StationaryObject
there is also a column with Speed in KMH "SpeedKMH" which is a normal column not a calculated one
I followed the exact steps and the measure that turns time into seconds as a number works perfectly, the problem I have now is that the "outputmeasure" in @v-yuezhe-msft gives the following error when I try to display it in a visual:
"Calculation error in measure [outputmeasure]: A table of multiple values was supplied where a single value was expected"
the measure itself works but I can't get it to display something ..
Regards, L.Meijdam (excuses for the late response)