CONTAINSSTRING Function (DAX)
How does the CONTAINSSTRING function (DAX) work?
The CONTAINSSTRING function (DAX) returns TRUE or FALSE indicating whether one string contains 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 textstring.
Related Blog Posts
Related Support Forum Posts
Understanding DAX Formula
Developing Complex Dax functions
Considerations when using the CONTAINSSTRING function
- CONTAINSSTRING is not case-sensitive.
- You can use
?and*wildcard characters. 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 |
Related Course Modules
DOWNLOAD
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.
