Forum Discussion
How to remove rows based on a condition
Hi everyone, I have a table in power query. There is column in the table by name 'order_line_id'. This column has duplicates which ideally shouldn't. I need to remove the rows with duplicate order_li...
I guess you could add an index, to the table, then sort it descending and then apply remove the duplicates?
Kudos and mark as solution appreciated.
This method isn't working! I tried adding an index column and then sorting it in decending order and then remove duplicates from order_line_id. No matter I sort it or leave it. It's removing the line that I want to retain!!šµ
