Forum Discussion

heimk008's avatar
heimk008
Frequent Visitor
8 years ago
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...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Yes:

     

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

A 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).

heimk008's avatar
heimk008
Frequent Visitor
8 years ago

MarcelBeug,

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's avatar
    MarcelBeug
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Yes:

     

    • JamesB23's avatar
      JamesB23
      New Member
      1 year ago

      Thanks for this ğŸ™Œ