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
Hi Anonymous,
This is what the data of my table looks like (note speed here is still in KM/H,I use a created M/S column)
| TimeLapse | StationaryObject | MSinceSObject | Speed | MovingObject |
| 10:00:00 | X | 50 | 70 | K1 |
| 10:10:00 | X | 100 | 90 | K1 |
| 10:20:30 | Y | 30 | 100 | K1 |
| 10:30:00 | Y | 70 | 90 | K1 |
| 10:35:00 | Y | 110 | 120 | K1 |
| 10:40:50 | Z | 20 | 90 | K1 |
| 10:51:00 | Z | 70 | 100 | K1 |
MSinceSObject represents the amount of meters since the movingobject passed the stationary object, I calculated the exact time the moving object was at the StationaryObject called "TimeAtPoint"
From that "TimeAtPoint" we wanted to know the average so that made
AverageTimeAtPoint =
CALCULATE(
AVERAGE(Table1[TimeAtPoint]);
ALLEXCEPT(Table1;Table1[StationaryObject])
)
the last thing I want to know is the distance between the stationary points.
L.Meijdam
Anonymous,
What formula do you use to create TimeAtPoint? Could you please post expected result based on the above complete data? Do you want to calculate the distance between different Stationary Objects or the distance between same Stationary Objects that have different TimeLapse?
Regards,
Lydia