Filtered new table

Hi,

How can I create a summary table with :

Assuming "S3" is the final status, how can I create a new table in Power BI that filters all those records who have the final status of "S3" and only show the initial record. In this case, Name = A has the final status of S3, so we do not want to show that value. For the remining, we only want to show the initial status record (Status = S1). The O/P in the above example would be: