Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Table Replace Value multiple condition

= Table.ReplaceValue(#"Expanded Code",each ([Geographical]="" or Text.Contains([Geographical],"INV")=true),"TBA",Replacer.ReplaceValue,{"Geographical"})   want to replace value to "TBA" if coulumn ...
Need Help
  • gpoggi's avatar
    gpoggi
    6 years ago

    Hi Anonymous ,

     

    Let me know if I get you well but this option helps you with what you need?

     

    https://drive.google.com/open?id=1LlxMa2ScsJpsf0ZcCJ31vo5a0kyvbIZT

     

    Also there are other options like custom column and create a new column based on other column values  but if you need to use the replace function in the same column that is how I would do it.

     

    Any question, just let me know.

     

    Regards,

     

    Gian Carlo Poggi

gpoggi's avatar
gpoggi
Responsive Resident
6 years ago

Hi Anonymous ,

 

Let me know if I get you well but this option helps you with what you need?

 

https://drive.google.com/open?id=1LlxMa2ScsJpsf0ZcCJ31vo5a0kyvbIZT

 

Also there are other options like custom column and create a new column based on other column values  but if you need to use the replace function in the same column that is how I would do it.

 

Any question, just let me know.

 

Regards,

 

Gian Carlo Poggi

gvg's avatar
gvg
Post Prodigy
5 years ago

Hi,

How do I change this to be used in a function with column name as a variable ?