Many times when I’m build an app, I need to know:
In order to accomplish this now, I have to either:
Let’s say I have an Orders table, and I want to know the “Sales Person” that entered the last order. To accomplish this inside a single column, I would have to create a formula similar to this:
LOOKUP(MAXROW(Orders, CreationDateTime, [OrderID] = [_ThisRow].[OrderID]), Orders, OrderID, Order_SalesPerson)
It would be most excellent if a hybrid formula could be introduced that was super efficient and allowed for this dual-behavior.
As always, thanks for considering! (^_^)