Forum Discussion
Multiplication with measure
Hi all, I want to do a multiplication which looks like this: TimeDifference * SpeedM/S // TimeDifference =Max(Table1[TIME]) - MIN(Table1[TIME]) // TIME = a Calculated column SpeedM/S = ...
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
