Lookup function for initial value

[Linda_Marita_La]

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.

[Steve]

Try:

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

[Linda_Marita_La]

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

[Linda_Marita_La]

It was success! Thank u!