Replacing values in Power Query Editor

[Emil_Yusifov]

Hello.

In a column I have duplicating values.

I just want to replace a duplicated value only in one row.

Replacing values in Power Query Editor using context menu Replace Values menu item, causes all duplicates of replaced value replaced to new one in a current selected column.

What I should do to replace only value only in current row ? 

[v-chuncz-msft]

@Emil_Yusifov 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Power-Query-change-input-data/m-p/595986#M283079

[Emil_Yusifov]

Hi, v-chuncz-msft.

Thanks for reply.

I modified and made it to work with my case, the formula described on that post. It works.

Simple example. Suppose we have Red Apples of $10 and Green Apples of $20. Let change all apples that s price is $10:

= Table.ReplaceValue(#"Changed Type", each [Price], each if [Price] = 10 and [Fruit]="Apple" then 20 else [Price], Replacer.ReplaceValue, {"Price"})

It is a way of automation, and very useful in convenient cases.

In other hand when click and change some cells case, it should be better to have a menu or direct rewrite opportunity of doing this.

Best

Emil