CONTAINSSTRINGEXACT
Applies to: Calculated column Calculated table Measure Visual calculation
Returns TRUE or FALSE indicating whether one string contains another string.
Syntax
CONTAINSSTRINGEXACT(<within_text>, <find_text>)
Parameters
Term | Definition |
---|---|
within_text | The text in which you want to search for find_text. |
find_text | The text you want to find. |
Return value
TRUE if find_text is a substring of within_text; otherwise FALSE.
Remarks
CONTAINSSTRINGEXACT is case-sensitive.
Example
DAX query
EVALUATE
ROW(
"Case 1", CONTAINSSTRINGEXACT("abcd", "bc"),
"Case 2", CONTAINSSTRINGEXACT("abcd", "BC"),
"Case 3", CONTAINSSTRINGEXACT("abcd", "a*d"),
"Case 4", CONTAINSSTRINGEXACT("abcd", "ef")
)
Returns
[Case 1] | [Case 2] | [Case 3] | [Case 4] |
---|---|---|---|
TRUE | FALSE | FALSE | FALSE |