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
Are both TimeDifference and SpeedM/S calculated columns or is SpeedM/S a measure? I'm going to assume columns. So, for measures, you need to do some sort of aggregation on columns, like:
MyMeasure = SUM(TimeDifference) * SUM(SpeedM/S)
Hi Greg_Deckler,
I am sorry for the confusion, TimeDifference is a measure. What I meant in my post was that TimeDifference uses a Calculated column for its calculation.
SpeedM/S is a calculated column.
TimeDifference is a measure
what I want to achieve is to calculate the distance. by multiplying the time from TimeDifference with SpeedM/S
Anonymous
In such case:
measure = [timedifference] * sum(speedM/S)
Hi bsas,
This measure works but I am getting unexpected results from it.
For example when the time difference is 0:05:00 the number that comes out of my measure is 0,50 while the speed in that difference was around 26 Meter per second.
Am I doing something wrong ?
The thing I am trying to achieve here is to know the distance covered in that time
