how to remove not fully duplicates power bi

Question

After marge I have some problems with not full dublicates that should be removed. Have I can solve this without new collom&nbsp;

lbendlin · Answer

Deduplication in Power Query can be finely controlled. You can choose which columns should be included in the decision.&nbsp; By default (in my opinion a bad default)&nbsp; only the currently selected column is used for the deduplication.&nbsp; You can modify the Power Query code to include all the columns that are important for your scenario.&nbsp;

kristimur · Answer

Could you please show on screen?

lbendlin · Answer

Let's assume you have this table

You can deduplicate the entire table or you can deduplicate groups of individual columns.

&nbsp;
&nbsp;

&nbsp;

kristimur · Answer

Yes but this is 2 colums and I need to base on 3, like this&nbsp;

lbendlin · Answer

Please provide sanitized sample data that fully covers your issue.https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216Please show the expected outcome based on the sample data you provided.&nbsp;

Forum Discussion

how to remove not fully duplicates power bi

5 Replies

Related content

remove duplicate value within a row

Removing Duplicates

How to stop PowerBI from automatically removing duplicates.

Removing duplicates

Remove duplicates bug