Forum Discussion
Replace multiple values in columns without creating new columns
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
Hi,
Yes I know about this function, but I was hoping there was a dax formula. There is about 50 values I have to replace in each column and there are at least 10 columns I have to have these values replaced in.
Thanks,
Elise
Solution SageHi 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