Replacing words in the table

[LucasPete]

Hi,

I want to replace the words in the table with other words.

I used this solution: https://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/

but in my case I get an error.

Do you know how to solve it?

https://drive.google.com/file/d/1kYNi-fK7q6Mf3t1YBJpsci7lOKUxoOAP/view?usp=sharing

[LucasPete]

This is unrelated, because as you can see, the author of the solution to which I added a link does it this way.

[lbendlin]

You provided a little too much sample data.  Please limit your sample to just the request. 

[LucasPete]

What do you mean? too many pattern words or too many words in the table that need to be changed?

[lbendlin]

It would be easier to work on your problem if there wasn't so much extra stuff (visuals, tables and query steps) that may or may not be related to the issue.  If you can limit the sample data to the essence of the problem then that would help.

You have one step called "Text"  - That is likely a reserved word. See if changing the step name helps.