CONTAINSSTRING Function (DAX)
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>
)
How do you use the CONTAINSSTRING function?
The CONTAINSSTRING function is used to verify whether there is some text string.
Related Blog Posts
Related Support Forum Posts
DAX formula involving Variable and AverageX
Slicer for 30, 60, 90 days forward
Quick Measures using Averages
Considerations when using the CONTAINSSTRING function
CONTAINSSTRING is not case-sensitive but is accent-sensitive. You can use ? and * wildcard characters, and use ~ to escape wildcard characters.
Related Video Tutorials
Formula examples using the CONTAINSSTRING function
CONTAINSSTRING(“abcd”, “bc”)
CONTAINSSTRING(“abcd”, “a*d”)
CONTAINSSTRING(“abcd”, “ef”)
[Case 1] | [Case 2] | [Case 3] | [Case 4] |
---|---|---|---|
TRUE | TRUE | TRUE | FALSE |