How does the CONTAINSSTRING function (DAX) work?

The CONTAINSSTRING function (DAX) returns TRUE or FALSE to indicate if one string has another string.

CONTAINSSTRING Formula Syntax

CONTAINSSTRING(
<within_text>, <find_text>
)

The CONTAINSSTRING function is used to verify whether there is some text string.

CONTAINSSTRING is not case-sensitive but is accent-sensitive. You can use ? and * wildcard characters, and use ~ to escape wildcard characters.

CONTAINSSTRING(“abcd”, “bc”)

CONTAINSSTRING(“abcd”, “a*d”)

CONTAINSSTRING(“abcd”, “ef”)

[Case 1]	[Case 2]	[Case 3]	[Case 4]
TRUE	TRUE	TRUE	FALSE