Finding one Value of with Max Date

[#1]

Hi all

I have a straight table i need to pull only 1 value based on max date and project. suggest me

Script used to derive the data.

Trans3:
Load
ProjectID_SYS,
[Updated On],
[Value Before Update] as N_Customer_Traction_Status
Resident [Project Metrics History]
where [Metric Name]='Customer Traction Status';

Trans4:
load
ProjectID_SYS,
if([Metric Name]='Customer Traction Status',Timestamp(Max([Updated On]),'MM/DD/YYYY hh:mm:ss TT')) as Maxmetric
Group by ProjectID_SYS,[Metric Name];

[#2]

"TT" represents AM, PM in time

[#3]

Thank you i got it