How to replace row /perticuler cell value from column

[Amardeep100115]

Hi,

I have a teble from which i want to replace a cell value with new one, let say 

a raplace with B

C raplace with D

i have a table with those details where old and new 

please help me how we can do this with query editor

Thanks

[Pragati11]

Hi @Amardeep100115 

In query editor, right click on your cell value and select "Replace Values".

If multiple replacements are required, right click on your column and select "Replace Values".

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Amardeep100115]

i have saperate table with Old and new value and i want them need to be in another table's cell where old value have to be replaced with new one

[v-lili6-msft · Accepted solution]

HI  @Amardeep100115 

If so, you could try this simple way to get it:

Basic data:

Step1:

Merge table with that replacedetail table

Step2:

Expand the column

Step3:

Add a custom comndition column

Step4:

Now remove Type and After column, Rename this new custom column:

and here is sample pbix file, please try it.

Regards,

Lin