CONTAINSSTRINGEXACT Function (DAX)

How does the CONTAINSSTRINGEXACT function (DAX) work?

The CONTAINSSTRING function (DAX) verifies if there is a text string, while the CONTAINSSTRINGEXACT is similar in nature but is case sensitive. This function returns TRUE or FALSE to indicate whether one string contains another string.

CONTAINSSTRINGEXACT Formula Syntax

CONTAINSSTRINGEXACT(
     <within_text>, <find_text>
)

How do you use the CONTAINSSTRINGEXACT function?

The CONTAINSSTRINGEXACT function is used to find text string in another text string. It does not accept wildcards to perform the search.

Related Blog Posts

Related Support Forum Posts

DAX formula involving Variable and AverageX
Calculating Average and using DateMonth
Quick Measures using Averages

Considerations when using the CONTAINSSTRINGEXACT function

When using the CONTAINSSTRINGEXACT function, it does not compare the exact value and will not accept wildcards.

Related Video Tutorials

Formula examples using the CONTAINSSTRINGEXACT function

CONTAINSSTRINGEXACT(“abcd”, “bc”)

CONTAINSSTRINGEXACT(“abcd”, “BC”

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

[Case 1][Case 2][Case 3][Case 4]
TRUEFALSEFALSEFALSE

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