Forum Discussion
Solved
Remove duplicate rows based on max value of a different column
Hello! I have a set of data that I am trying to remove duplicates from based on the number of filled cells per row. The data is form submissions that have a person's email address and then a numb...
Yes:
Thanks for the response , however that doesn't seem to work. Even when I sort by decending and then remove duplicate emails it still takes away some of the emails that have the highest number of filled cells.
For example:
before-
after -
you can see that I now lost the entry with 16 filled cells.
MarcelBeug
Community Champion
Community ChampionA known issue with sorting and removing duplicates is that you need to buffer the table in between.
You might wrap your sort step like: Table.Buffer(your sortcode).
still relatively new to Power BI, what does "wrap your sort step like: Table.Buffer(your sortcode)" actually mean? are you able to show me by chance?
- MarcelBeug
Yes:
Thanks for this 🙌
