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 = Divide(Table1[SpeedKM/H];3,6)
Thanks in advance !
L.Meijdam
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
28 Replies
Hi Anonymous,
Try to use Value(timedif)*value(speed). In case it does not work vecouse of formats, please draw your table with few test data.
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)
Hello,
Try use it
NameMeasure = sumx(table_of_calculated_column; TimeDifferenceMeasure*SpeedM/S)
Sorry my delay, but is this answer correct?
