REPLACE DAX Function (Text)
Replaces part of a text string with a different text string.
Syntax
Parameter | Attributes | Description |
---|---|---|
OldText |
The string of text that contains the characters you want to replace. |
|
StartPosition |
The position of the character in old_text that you want to replace with new_text. |
|
NumberOfCharacters |
The number of characters that you want to replace. |
|
NewText |
The replacement text. |
Return values
The resulting string after applying the replacements.
Remarks
The StartPosition starts from 1 for the first character in the string.
Related functions
Other related functions are:
Last update: Jan 23, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/replace-function-dax