Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 equal tables, the second has the same data as the first and also some new records. How can I delete the duplicate data that appears in both tables?
I created an append relationship because every week I will be adding new files with new data but sometimes that data can be repeated, how can I remove this duplicate data?
For example, this is my table 2 which contains new values:
This is my table 1 which contains these data, the same data exists in the table 2, when I created the append relationship, my report show duplicate information, how can remove the duplicate data (from the table 2)?:
Thanks.
Solved! Go to Solution.
Hi @odalistt
In Edit Queries, after appending,
Add a column to merge all columns into one column
Then remove duplicates
Then you could remove the merged column without reflecting the table
Best Regards
Maggie
Hi @odalistt
In Edit Queries, after appending,
Add a column to merge all columns into one column
Then remove duplicates
Then you could remove the merged column without reflecting the table
Best Regards
Maggie
Go to Edit Queries
Select the Remove Rows dropdown on the Home tab
Select Remove Duplicates
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |