Lookup function for initial value

Hi there!

In my app my workers have to register “Order number”, “Date”, “From time” “To time” in their deliveries throughout the day.
Wich expression can i use to make initial value on “From time” to be the last registered “To time” with the match of todays date?
The app is used by multiple users so i have to incorperate “uniqe user” in this for them to get their last registeres and not another coworkers registration.

Try:

MAX(
  SELECT(
    MyTable[To Time],
    AND(
      ([_THISROW].[uniqe user] = [uniqe user]),
      (TODAY() = [Date]),
      (TIMENOW() >= [To Time])
    )
  )
)
2 Likes

Thank you Steve! This makes a lot of sense! I’ll try and keep you posted! :slight_smile:

1 Like

It was success! Thank u!

1 Like