cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Remove Duplication

Hi,

 

looking for a function, in excel, Remove Duplicates in Power Bi.!

Remove duplication.PNG

 

 

 

 

 

Thanks,

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Remove Duplication

Hi, In the Query Editor, select all columns that you want to search duplicates in, right click and select Remove Duplicates.
Community Support Team
Community Support Team

Re: Remove Duplication

Hi @colourfullife 

 

Kindly mark the helpful answer as a solution if you feel that makes sense.You may also find it under 'Remove Rows' in query editor.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User
Super User

Re: Remove Duplication

Hi, In the Query Editor, select all columns that you want to search duplicates in, right click and select Remove Duplicates.
Community Support Team
Community Support Team

Re: Remove Duplication

Hi @colourfullife 

 

Kindly mark the helpful answer as a solution if you feel that makes sense.You may also find it under 'Remove Rows' in query editor.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.