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

bsas's avatar
bsas
Post Patron
8 years ago

Anonymous

 

What is the format of time you're using?

 

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi bsas,

 

I am using H:mm:ss

  • bsas's avatar
    bsas
    Post Patron
    8 years ago

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

    Hi bsas,

     

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

     

  • bsas's avatar
    bsas
    Post Patron
    8 years ago

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