Forum Discussion
Count duplicate values across multiple columns
Maybe this is just language, but if you want to keep the dupilcates and count them, then surely you will end up with this.
First Name Last Name Address Number of Duplicates
Row XYZ John Smith 123 Sandpiper Lane 3
Row XYZ John Smith 123 Sandpiper Lane 3
Row XYZ John Smith 123 Sandpiper Lane 3
If you want to remove the duplciates and keep 1 copy of every row, then you will end up with this.
First Name Last Name Address Number of Duplicates
Row XYZ John Smith 123 Sandpiper Lane 3
You can also do this in Power Query. Just select Group By, and then select Count. The button is on the home tab to the right hand side of the menu
Yes, Advanced Grouping works. Thank you
In power query (get data), you can highlight multiple columns and then either remove duplicates or keep duplicates.
Thank you,
So I want to keep the duplicates, but I also want a "count" of how many duplicates I have. And those duplicates would be across multiple columns.
For example:
First Name Last Name Address
Row XYZ John
Thank you,
So I want to keep the duplicates, but I also want a "count" of how many duplicates I have. And those duplicates would be across multiple columns.
For example:
First Name Last Name Address Number of Duplicates
Row XYZ John Smith 123 Sandpiper Lane 3
The number of duplicates column would show me that I have 3 duplicates of rows with this identical data.
I can do this in Excel and Access. How can I accomplish the same in Power BI?
Maybe this is just language, but if you want to keep the dupilcates and count them, then surely you will end up with this.
First Name Last Name Address Number of Duplicates
Row XYZ John Smith 123 Sandpiper Lane 3
Row XYZ John Smith 123 Sandpiper Lane 3
Row XYZ John Smith 123 Sandpiper Lane 3
If you want to remove the duplciates and keep 1 copy of every row, then you will end up with this.
First Name Last Name Address Number of Duplicates
Row XYZ John Smith 123 Sandpiper Lane 3
You can also do this in Power Query. Just select Group By, and then select Count. The button is on the home tab to the right hand side of the menu