Forum Discussion
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 ...
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
Calling in the master of M, the principal of Power Query, the...well...you get the idea. Help ImkeF !!