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.

0 3 294
3 REPLIES 3

Steve
Participant V

Try:

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

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

It was success! Thank u!

Top Labels in this Space