SUBSTITUTE Replaces existing text with new text in a text string.


SUBSTITUTE(text, old_text, new_text, instance_num)


text – The text in which you want to substitute characters, or a reference to a column containing text.
old_text The existing text that you want to replace.
new_text The text you want to replace old_text with.
instance_num (optional) The occurrence of old_text you want to replace. If omitted, every instance of old_text is replaced

Return Value

A string of text.

Reference Data

DAX Functions / Text Functions / SUBSTITUTE