cancel
Showing results for
Search instead for
Did you mean:
Highlighted
LMeijdam Established Member

## 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

1 ACCEPTED SOLUTION

Accepted Solutions v-yuezhe-msft
Moderator

## Re: Multiplication with measure

@LMeijdam,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
28 REPLIES 28
bsas Member

## Re: Multiplication with measure

Hi @LMeijdam,

Try to use Value(timedif)*value(speed). In case it does not work vecouse of formats, please draw your table with few test data. Super User

## Re: Multiplication with measure

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)`

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

LMeijdam Established Member

## Re: Multiplication with measure

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

bsas Member

## Re: Multiplication with measure

@LMeijdam

In such case:

`measure = [timedifference] * sum(speedM/S)`
LMeijdam Established Member

## Re: Multiplication with measure

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

rcspaiva Regular Visitor

## Re: Multiplication with measure

Hello,

Try use it

NameMeasure = sumx(table_of_calculated_column; TimeDifferenceMeasure*SpeedM/S)

LMeijdam Established Member

## Re: Multiplication with measure

Hi @rcspaiva,

When i try your formula it returns 0.

bsas Member

## Re: Multiplication with measure

@LMeijdam

Could you please share sample of your data table.

rcspaiva Regular Visitor

## Re: Multiplication with measure

Hello @LMeijdam,

Could share some data, like three examples and the result that u are expecting.

Its going to be more easy to figure out...

## Helpful resources

Announcements Top Ideas Top Kudoed Authors
Users Online
Currently online: 41 members 943 guests
Recent signins:
• LatinoBI • OwenAuger • power_firm • Jayendran • Tiago_Cirilo • ElizabethTachji Please welcome our newest community members:
• Tiago_Cirilo • abhishek_a4 • hunglai • dimsarin • DataPro • NumeroENAP • pamella14 