Formula - How to Find Most Recent Row (Based on Conditions) and Retrieve Value from a different Column
Hi - I need help to put a formula to find a most recent row based on conditions and retrieve a different column value / perform calculations between two row parameters (DateTime). Below data table (also attached) has : Asset, DateTime, Discrete and Action columns . Data is sorted based on Asset first and then DateTime (ascending)There is also a Table variable days_threshold = 4. Action(Desired) ...