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]
TRUETRUETRUEFALSE

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership