Forum Discussion
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_AngyalMost 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
- AnonymousNot applicableThat's a job for Power Query, not for DAX.
Best
D - AzejamRegular Visitor
Thank you Cristian_Angyal