Reply
Member
Posts: 61
Registered: ‎02-06-2019
Accepted Solution

Remove Duplication

Hi,

 

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

Remove duplication.PNG

 

 

 

 

 

Thanks,


Accepted Solutions
Super User
Posts: 4,110
Registered: ‎01-14-2017

Re: Remove Duplication

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

View solution in original post

Highlighted
Community Support Team
Posts: 1,596
Registered: ‎07-25-2018

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.

View solution in original post


All Replies
Super User
Posts: 4,110
Registered: ‎01-14-2017

Re: Remove Duplication

Hi, In the Query Editor, select all columns that you want to search duplicates in, right click and select Remove Duplicates.
Highlighted
Community Support Team
Posts: 1,596
Registered: ‎07-25-2018

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.