Forum Discussion
Duplicate Rows after Power BI Merge
I have two spreadsheets of rented Units that have different accounting data I want to consolidate. The spreadsheets are brought into different Power BI tables and are merged using a column I create from joining the same data in both tables. Everything is fine in each table until I expand the newly merged colum. At this point I have duplicate rows in different portions of the merged table. I have tried highlighting the 7 affected columns and Remove Duplicates but nothing is removed. Please advise as to what I am doing wrong.
Thank you
7 Replies
I don't quite understand what you are trying to do. Are you intentionally using a fuzzy match?
What do your original tables look like and what should the final result look like?
Thank you for the response. I am using the fuzzy match as it is the only one I have found that matches the columns correctly other than column 362-364 those columns should have a null returned not the TRI 2-207. I am merging two tables where I have created a Unit Building column common to both tables. The tables have differing info that I would like to have in one place.
Thank you again for your assistance.
Hi All,
I am not sure if the issue was solved or not but I had a case like below and solved it with append queries. Here is the situation:
Table 1
B/L Number Revenue 1 100
2 200
Table 2
B/L Number Cost Amount 1 -50 1
-50 2
-50 3
-200 When I selected merge it was dupplicating the the line in revenue table because there were 2 of the some b/l number. So when I selected append here is the result:
B/L Number Revenue Cost 1 100 -50 1 null -50 2 200 -50 3 null -200
