CONTAINSSTRINGEXACT Function (DAX)

How does the CONTAINSSTRINGEXACT function (DAX) work?

The CONTAINSSTRINGEXACT function (DAX) returns TRUE or FALSE indicating 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 in finding text string in another text string. Also does not accept wildcards to perform the search.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CONTAINSSTRINGEXACT function

Consideration when using CONTAINSSTRINGEXACT function is that it does not compare exact value. It does work similarly to CONTAINSSTRING but is case sensitive.

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

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.