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
Anonymous,
What is the TIME column you used in the following formula? If the TIME column is AverageTimeAtPoint column, please show us the data of the TravelTimeTformat column.
TimeDifference =Max(Table1[TIME]) - MIN(Table1[TIME])
Regards,
Lydia
Anonymous,
As suggested earlier in this post I created a calculated column with the following formula:
time = MINUTE(Table1[AverageTimeAtPoint])*60+SECOND(Table1[AverageTimeAtPoint])
So in the Timedifference code that looks like this:
TimeDifference = MAX(Table1[time])-MIN(Table1[time])
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,
LydiaHi Anonymous,
Thank you very much for your time it finally works like expected ! :)
Have a very good day !