Forum Discussion
Help with Lookupvalue and Time Conditions
Hello all,
I'm trying to create a new table with some informations from 2 others tables, but I need to compare the time without the seconds, and if the minutes are odd, I need to put in the next even minute.
This is the table "Speed Mac"
This is the table "Stops"
And the result that I want is "TimeStopSpeed"
Thankyou for any help!!
CHEduardo , create a new column in Stops
New Minute =
var _time = datevalue([stopbegtime]) + time(hour([stopbegtime]), minute([stopbegtime]), 0)
return
if(mod(minute(_time) , 2) =0, _time , _time +time(0,1,0)
Now create a new column
Speed Mac
New col =
var _time = datevalue([repTime]) + time(hour([repTime]), minute([repTime]), 0)
return
maxx(filter(Stops, Stops [New Minute] = _time ) , Stops[Text])
1 Reply
CHEduardo , create a new column in Stops
New Minute =
var _time = datevalue([stopbegtime]) + time(hour([stopbegtime]), minute([stopbegtime]), 0)
return
if(mod(minute(_time) , 2) =0, _time , _time +time(0,1,0)
Now create a new column
Speed Mac
New col =
var _time = datevalue([repTime]) + time(hour([repTime]), minute([repTime]), 0)
return
maxx(filter(Stops, Stops [New Minute] = _time ) , Stops[Text])