SUBSTITUTE DAX Function in Power BI
The SUBSTITUTE DAX function replaces existing text with new text in a text string and returns a string of text.
DAX Syntax SUBSTITUTE(text, old_text, new_text, instance_num)
Example: Create a Calculated Column.
DAX
Column = SUBSTITUTE(Query1[Company], Query1[Company], "TCS")
The output of the above dax code is shown below:
