Replace Duplicate values with Blank, and keep only one in other column

[raghavkrishna]

Hello All,

I am trying to create a new column with the existing one. In this new column I want to keep only one out of all available duplicate values in the same row. Rest all duplicate values needs to be replace by blanks or null.

Below is the input for my data and also the expected output

Any help would be appreciated

[rohitpoojari]

Hi Amit, Can this be done in Query Editor? replacing the subsequent duplicated value with null

[rohitpoojari]

Thanks

[Katie-Farrand12]

Hi @amitchandak 

Thank you for the above. I tried it and it worked perfectly. However I am trying to achieve something slightly different. 

If there is a duplicate; I want to remove it from the list completely; as per the below. Do you have any advice?

Also, I need to do this in Power Query in M Language.

Identifier	Unique Identifier
678398	678398
890462	890462
869302	869302
673020
673020
859396	859396
674811
674811
829487	829487

[amitchandak · Accepted solution]

@raghavkrishna , First add an index column in Power Query

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

Then add this new column in dax

New column=  if([Index] = minx(filter(Table, [Column1] = earlier([[Column])) , [index]) , [Column2], blank())

refer: Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8