Multiplication with measure

[Anonymous]

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

[v-yuezhe-msft · Accepted solution]

@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]

Hi @v-yuezhe-msft,

Thank you very much for your time it finally works like expected ! 🙂

Have a very good day !

[bsas]

@Anonymous

What is the format of time you're using?

00:10:00 - means 10 min or sec?

[Anonymous]

Hi @bsas,

I am using H:mm:ss

[bsas]

@Anonymous

try to use calculated column for time:

time1 = MINUTE('time and speed'[time])*60 + SECOND('time and speed'[time])

than use it in measure.

[Anonymous]

Hi @bsas,

I am sorry in which measure did you want me to use it ?

[bsas]

This is how I turned minutes from your "time" into seconds as number.

[bsas]

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.