Return Most Recent Entry In Summary Table

Hi Anonymous one possible solution: create new table Test as following
If this post helps, accept as solution to help other members find it more quickly. Kudos appreciated.

Test=

VAR __max_finish_date = [MaxFinish] --calculating max finish time
VAR __summarize_table_temp =
SELECTCOLUMNS (
FILTER (
SUMMARIZE (
'Aeromark Data',
'Aeromark Data'[Work Order No],
'Aeromark Data'[Resource Name],
'Aeromark Data'[Start Time],
'Aeromark Data'[Finish Time],
'Aeromark Data'[Time on Site - Decimal],
'Aeromark Data'[Status]
),
'Aeromark Data'[Status] = "Complete"
|| 'Aeromark Data'[Status] = "Incomplete"
&& 'Aeromark Data'[Finish Time] = __max_finish_date
),
"work Order No", 'Aeromark Data'[Work Order No],
"Status", 'Aeromark Data'[Status]
)
RETURN
__summarize_table_temp