Forum Discussion

RMDNA's avatar
RMDNA
Solution Sage
9 years ago
Solved

Displaying rows with a duplicate same-column value

Hey all,   Relatively new to PBID, and unfamiliar with backend DAX queries. I'm probably overlooking something, as it seems this should be simple.   I have a table structured as below:   Row   ...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi There,

     

    You can use powerquery for such tasks. To identify all the rows with duplicate unique IDs,

     

    You should perform these steps in order,

     

    1. In PowerQuery Mode, Perform Group by operatio. This is under the Transform Tab. 

    In Group By, Follow the steps shown in screen shot.Group ByFilter out all the records in duplicate records column with Value 1Expand the Oppty column by clicking on the two sided arrowsRemove duplicate records and unique IDs column and rename the headers

     

    Thanks & Regards,

    Bhavesh

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi There,

 

You can use powerquery for such tasks. To identify all the rows with duplicate unique IDs,

 

You should perform these steps in order,

 

1. In PowerQuery Mode, Perform Group by operatio. This is under the Transform Tab. 

In Group By, Follow the steps shown in screen shot.Group ByFilter out all the records in duplicate records column with Value 1Expand the Oppty column by clicking on the two sided arrowsRemove duplicate records and unique IDs column and rename the headers

 

Thanks & Regards,

Bhavesh

KenSkinner's avatar
KenSkinner
Helper I
7 years ago

Brilliant!  Straight forward, easy solution to walk through and it worked like a champ.  Now I've just got to figure out why I'm getting duplicate records from a customer master table that was previously not giving me duplicates.   Until I figure it out I'll just remove the duplicates and move forward.

 

Many thanks!