Forum Discussion
Power Query - Remove Duplicate - secondary Value
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
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.
2 Replies
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
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.
