Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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.
This worked, thank you!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |