Forum Discussion

Azejam's avatar
Azejam
Regular Visitor
6 years ago
Solved

Identifying duplicates

Hello,

 

I have a table with coordinates and company name. I need to find coordinates that are the same but have a different company name.  Any thoughts?

 

  • I would use Power Query and Group By 2 columns (Platuma and Ilguma) and count the values.

    If you can paste as values some data we might "play-along" a bit.

     

     

    If you liked my solution please give it a thumbs up 👍

    If I did answer your question please mark my post as a solution .

    Thank you !

     

     

    Cristian

     

3 Replies

  • Cristian_Angyal's avatar
    Cristian_Angyal
    Most Valuable Professional

    I would use Power Query and Group By 2 columns (Platuma and Ilguma) and count the values.

    If you can paste as values some data we might "play-along" a bit.

     

     

    If you liked my solution please give it a thumbs up 👍

    If I did answer your question please mark my post as a solution .

    Thank you !

     

     

    Cristian

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    That's a job for Power Query, not for DAX.

    Best
    D