Power Query - Remove Duplicate - secondary Value

[Anonymous]

Hi Team,

Power query : 

I have Duplicate Item code in a column and need to remove secondary value like A2 , 02...

The below table Item code repeated 2 time , i have to keep 1st one and remove 2nd one like A2, 02.

Please help me.

Thanks,

KV's

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

You can remove duplicate in PQ but you need to use 'replace values' first.

Like this:

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Break in power Query Based on Split into 1 (Part1 , Part 2)  -https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

And then create one more column

Part3  = Text.end([Part2],1)

and then filter on 1 in power query and save