cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
LMeijdam Established Member
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
Moderator 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
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
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
Established Member

Re: Multiplication with measure

Hi @Greg_Deckler,

 

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
Member

Re: Multiplication with measure

@LMeijdam

 

In such case:

 

measure = [timedifference] * sum(speedM/S)
LMeijdam Established Member
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
Regular Visitor

Re: Multiplication with measure

Hello,

 

Try use it

 

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

 

 

LMeijdam Established Member
Established Member

Re: Multiplication with measure

Hi @rcspaiva,

 

When i try your formula it returns 0.

 

 

bsas Member
Member

Re: Multiplication with measure

@LMeijdam

 

Could you please share sample of your data table.

rcspaiva Regular Visitor
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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 41 members 943 guests
Please welcome our newest community members: