Editor: how to remove duplicates selectively based on the condition

Hi All,

I use PowerBI to analyze efficiency of our mass email campaigns. I get a table that contains all emails that were sent.

Each row is for one email message to one email address, e.g.:

[email protected]  1st email 4/5/19

[email protected] 2nd email 4/7/19

[email protected] 3rd email 4/9/19

I aslo see if the email was openned, clicked, replied (I have the corresponding date and time columns. they are empty if no action).

I have a column with the email number I sent, e.g. 1 for the first email, 2 for the second etc.

Also, I have a column that aggregates dates of the interaction with my emails (either open or click or reply or unsubscribe date).

I want to get a list with unique email addresses with the lattest interaction (if any happened).

I tried to sort by filter by Interaction date and then remove duplicates in Editor. However, I always get the list with the number 1 email in the list.

I use this table to merge with the other one so it is important for me to have the unique emails, but it would be awesome if I could get the latest interaction date for further analysis.

Any ideas how to accomplish it?