Sample Table:
Date Action Status
2/24/23 Inspection Pass
2/25/23 Inspection Pass
2/26/23 Inspection Fail
I'm trying to write an expression that will provide the status that has the latest date, in this case that would be Fail.
I tried: =Last(Fields!Status.Value, "DataSet1")
Would I need a MaxDate in there somewhere? Thank you.