Expression to return last item by date

SSAS and SSRS
#1

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.

#2

hi

this is a microsoft t-sql forum

SELECT 
    Max(Date)
FROM
   SampleTable

all depends on how your data is

#3

Oops, thank you.