Forum Discussion
Solved
Replace multiple values in columns without creating new columns
Hi, I am trying to figure out how to replace values in a column with corrisponding values on another table. I know the easiest way is a merge query. However, that will cause a lot of problems wi...
Hi elippe , Dax has replace and substitute functions - but anything you do with dax will result in a new column.
There are several power query solutions provided here that you may be able to replicate: https://community.powerbi.com/t5/Desktop/Power-Query-Replace-multiple-substrings-in-one-column/m-p/409573
johncolley
Solution Sage
Solution SageHi elippe , In Power Query you could use the replace values option - however depending on the number of different values you are needing to change it may be labour intensive
If this answer solves your problem please mark it as a solution!