cancel
Showing results for
Did you mean:
Established Member

## Re: Multiplication with measure

 Time StationaryObject SpeedMS MovingObject 10:00:00 A 20 X 10:10:00 C 20 X

Timedifference represents the time between StationaryObject A and C for example. So in this case Timedifference would be 00:10:00. the expected outcome would be the distance traveled by the moving object between those points

The column "Time" we see here is a calculated column which displays an average of when the MovingObject was at StationaryObject

there is also a column with Speed in KMH "SpeedKMH" which is a normal column not a calculated one

Member

## Re: Multiplication with measure

@LMeijdam

What is the format of time you're using?

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

Established Member

## Re: Multiplication with measure

Hi @bsas,

I am using H:mm:ss

Member

## Re: Multiplication with measure

@LMeijdam

try to use calculated column for time:

`time1 = MINUTE('time and speed'[time])*60 + SECOND('time and speed'[time])`

than use it in measure.

Established Member

## Re: Multiplication with measure

Hi @bsas,

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

Member

## Re: Multiplication with measure

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

Regular Visitor

## Re: Multiplication with measure

Sorry my delay, but is this answer correct?

Moderator

## Re: Multiplication with measure

@LMeijdam,

Create a calculated column using the formula below.
Column = MINUTE(Table1[Time])*60+SECOND(Table1[Time])

Then create the following measures in your table.
TimeDifference = Max(Table1[Column])- MIN(Table1[Column])
OutputMeasure = [TimeDifference]*VALUES(Table1[SpeedMS])

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

## Re: Multiplication with measure

I followed the exact steps and the measure that turns time into seconds as a number works perfectly, the problem I have now is that the "outputmeasure" in @v-yuezhe-msft gives the following error when I try to display it in a visual:

"Calculation error in measure [outputmeasure]: A table of multiple values was supplied where a single value was expected"

the measure itself works but I can't get it to display something ..

Regards, L.Meijdam (excuses for the late response)

Moderator

## Re: Multiplication with measure

@LMeijdam,

Do you create the table visual as shown in my screenshot? If not, please post the visual you create.

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.

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: 44 members 1,053 guests
Recent signins: