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])
)
)
)
Thank you Steve! This makes a lot of sense! I’ll try and keep you posted!
It was success! Thank u!
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |