Share via


REPLACE Function (DAX)

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Syntax

REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)

Parameters

Term

Definition

old_text

The string of text that contains the characters you want to replace, or a reference to a column that contains text.

start_num

The position of the character in old_text that you want to replace with new_text.

num_chars

The number of characters that you want to replace.

new_text

The replacement text for the specified characters in old_text.

Property Value/Return Value

A text string.

Remarks

Whereas Microsoft Excel has different functions for use with single-byte and double-byte character languages, PowerPivot for Excel uses Unicode and therefore stores all characters as the same length.

Example

The following formula creates a new calculate column that replaces the first two characters of the product code in column, [ProductCode], with a new two-letter code, OB.

=REPLACE('New Products'[Product Code],1,2,"OB")

See Also

Reference

Other Resources