cancel
Showing results for
Did you mean:
Highlighted
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)

L.Meijdam

1 ACCEPTED SOLUTION

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

Proud to be a Datanaut!

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

Member

## Re: Multiplication with measure

@LMeijdam

In such case:

`measure = [timedifference] * sum(speedM/S)`
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

Regular Visitor

## Re: Multiplication with measure

Hello,

Try use it

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

Established Member

## Re: Multiplication with measure

Hi @rcspaiva,

When i try your formula it returns 0.

Member

@LMeijdam

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

Announcements

Power BI Super User, Greg Deckler, explains

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 41 members 943 guests
Recent signins: