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 !
Go to Solution.
@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
Try to use Value(timedif)*value(speed). In case it does not work vecouse of formats, please draw your table with few test data.
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!
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
In such case:
measure = [timedifference] * sum(speedM/S)
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
Try use it
NameMeasure = sumx(table_of_calculated_column; TimeDifferenceMeasure*SpeedM/S)
When i try your formula it returns 0.
Could you please share sample of your data table.
Could share some data, like three examples and the result that u are expecting.
Its going to be more easy to figure out...
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.