Remove duplicate rows function not working

[vnarayan]

Hi,

I have been trying to remove duplicate rows by merging couple of columns together but it removes way more than just the duplicates. Is this a recurring issue?

Thanks,

Vivek

[amitchandak]

@vnarayan , if you want to delete a duplicate based on fill row. Click on the top right of the table so no table is selected and use delete duplicate.

If you want it based on columns, select those columns using shift or ctrl  and delete duplicate rows

Throwback- Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s
Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a