Forum Discussion
substitute multiple values
Anonymous
Please try with nested SUBSTITUTE function with similar DAX formula as below.
Column1_1 = SUBSTITUTE ( SUBSTITUTE ( SUBSTITUTE ( 'Table'[Column1], "Trust", "One" ), "Foundation", "One" ), "Endownment", "One" )Best Regards,
Herbert
If you're looking for a dynamic approach I think you need to return to the Query editor and M like this:
http://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/
If you're looking for a dynamic approach I think you need to return to the Query editor and M like this:
http://www.thebiccountant.com/2016/05/22/multiple-replacements-in-power-bi-and-power-query/
Hi all, thank you so much for helping. I want to accept everyone's reply as solution but Microsoft only allow one solution.
After looking into the solutions using M, I think it is a better solution rather using Dax if there is complex replacement involve.