How to replace text in a columns dynamically?

[gsb99]

I want to know  how to replace text value in a column where it is situated dynamically.

[Manoj_Nair]

@gsb99 - try this old pbi community link explaining how to replace text in a column dynamically - https://community.powerbi.com/t5/Power-Query/How-to-replace-values-of-dynamic-columns-using-values-f....

If this post helped your doubt, pls accept this as solution. Many Thanks

[djurecicK2]

Hi @gsb99 ,

 We might need a little more information. Have you looked at the SUBSTITUTE function?

https://learn.microsoft.com/en-us/dax/substitute-function-dax