Item records have two price fields Price_1 on Date_1 and Price_2 on Date_2. Price_2 and Date_2 may be null. See Starting Data below.
I want to extract only the most recent date and price pair for a given item. See Desired Output below.
Starting Data
Item | Date_1 | Price_1 | Date_2 | Price_2 |
Tacos | 2012-12-31 | 4.32 | 2022-03-01 | 6.75 |
Bike | 2018-05-04 | 8945.99 | Null | Null |
Desired Output
ITEM | Date (Most Recent) | Price (Most Recent) |
Tacos | 2022-03-01 | 6.75 |
Bike | Bike | 8945.99 |
Solved! Go to Solution.
@hellyars
A slightly different approach.