powerbipowerquerydata-analysispowerbi-desktopanalysis

Extract duplicate row based on three columns power query

Hi i want extract the duplicated row based on three columns in power bi (power query).

If all column are same with other row then extract.

In this case the column are name, surname and phone1.

I show you an example :

I need to create a column custom in power query for use in command description.

Thank you for help.

extract duplicate and use a table command description in a graph

Solution

  • Potentially this helps:

    remove all duplicate rows checking each column for matches

    #"Removed Duplicates" = Table.Distinct(Source)

    remove all duplicate rows by checking 3 columns

    #"Removed Duplicates" = Table.Distinct(Source, {"Column2", "Column1", "Column3"})

    check 3 columns and count number of occurrences. >1 means duplicates

    #"Grouped Rows" = Table.Group(Source {"Column1", "Column2", "Column3"}, {{"Count", each Table.RowCount(_), Int64.Type}})