Conditionally Remove Duplicate Rows - Power Query

[karmaimages]

Hi



I need to conditionally remove rows from a dataset within Power Query

Reference

Owner

Date

Department

I want to remove Duplicate References where Owner is "Joe Bloggs" Date = >31/12/2022 and department = "Finance"



So

Reference	Owner	Date	Department
123	Joe Bloggs	01/02/2023	Customer Service
123	Joe Bloggs	01/02/2023	Finance

On the above. I'd want to remove the duplicate row with reference "123" where Owner = "Joe Bloggs" and Date >31/12/2022 and Department = "Finance"



This should then leave the customer Service Row within the dataset



Is this possible to do, rather than manually doing it within the dataset?

 

[Kerryx]

Add a custom column with formula

if ( [Date] >= #date(2022, 12, 31) and  [Owner] = "Joe Bloggs"and  [Department] = "Finance") then 1 else 0)

then apply a filter