SUBSTITUTE

Syntax

SUBSTITUTE(<text>, <old_text>, <new_text>, <instance_num>)

Tutorial with example

In today’s video, we will learn how to use the DAX function SUBSTITUTE. Substitute changes text for another text. We will do two examples, how to substitute one value for another and how to substitute multiple values.

Download example file:

Not available

Remarks

Use the SUBSTITUTE function when you want to replace specific text in a text string; use the REPLACE function when you want to replace any text of variable length that occurs in a specific location in a text string.

The SUBSTITUTE function is case-sensitive. If case does not match between text and old_text, SUBSTITUTE will not replace the text.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode.