Removing Duplicates from entire table

[Anonymous]

Hi, What is the best way to remove duplicates from the whole table ? Right now it only lets me select 1 column at a time

[Anonymous]

Thanks @selimovd ! that works

[selimovd · Accepted solution]

Hey @Anonymous ,

if you have the possibility then remove them already in Power Query.

Select all the columns then go to "Remove Rows" and then "Remove Duplicates":

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi