Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 = ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

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

     

    Have a very good day !