Help with Lookupvalue and Time Conditions

[CHEduardo]

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

[amitchandak · Accepted solution]

@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])