Help on lookup to pull most recent value based on most recent date

[cwwazy]

Hi All,

I have an audit table that records the change to an account's information. I need to look up the most recent datetime and street address for the account only when the street_updated column is True and look it up by the cust_id.
In the example dataset below, I would expect my lookup output to be
cust_id: ABC1
datetime : 4/3/24 6:22 PM
street: 123 Forest

cust_id: ABC2
datetime : 4/3/24 6:22 PM
street: 789 Forest


Screenshot 2024-04-25 at 6.11.00 PM.png