Removing Duplicates Based on Another Column

[garye]

Hello,

I am trying to remove unnecessary rows in my data that are essentially incorrect now because there is a more updated row in there and it skews the numbers I am trying to analyze.

I have many columns in my data (which I need to keep), but essentially I am trying to remove the rows if the ACCOUNT_ID is the same but there is a 0 AND a 1 for the Funded column. Many ACCOUNT_ID will only have a 0, and I want to keep those, but if there are multiple rows for the same ACCOUNT_ID and the Funded column is a 1 and a 0 then I want to just keep the 1.

Rows 1 and 2 in the picture below are a good example of me just wanting to keep row 2 and delete row 1.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the attached file below.

I tried to create a sample pbix file like below, and one of ways to achieve this is to process in Power Query Editor.

In the sample pbix file, all steps are in the Test load query.

[garye]

This worked, thank you!