Forum Discussion

CHEduardo's avatar
CHEduardo
Frequent Visitor
4 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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