DAX Function Guide

CONTAINSSTRING
Empty image or helper icon

Sam McKay

CEO & Founder

How does the CONTAINSSTRING 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?

The CONTAINSSTRING function is used to verify whether there is some text string.

Related Blog Posts

Loading

Considerations when using the CONTAINSSTRING?

CONTAINSSTRING is not case-sensitive but is accent-sensitive. You can use ? and * wildcard characters, and use ~ to escape wildcard characters.

Related Video Tutorials

Loading

Formula examples using the CONTAINSSTRING

CONTAINSSTRING(“abcd”, “bc”)

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

CONTAINSSTRING(“abcd”, “ef”)

Related Courses

Loading