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

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.