SUBSTITUTE DAX Function

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