Forum Discussion
Multiplication with measure
Anonymous,
In your table, you have different SpeedM/S for different Stationary Objects. You would need to create a measure to calculate a average speed value, then calculate distance between objects.
TimeDifference = MAX(Table1[time])-MIN(Table1[time])
AverageSpeed = AVERAGE(Table1[SpeedM/S])
OutputMeasure = [TimeDifference]*[AverageSpeed]
Regards,
Lydia
| Time | StationaryObject | SpeedMS | MovingObject |
| 10:00:00 | A | 20 | X |
| 10:10:00 | C | 20 | X |
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
Post PatronAnonymous
What is the format of time you're using?
00:10:00 - means 10 min or sec?