DAX Function Guide

CONTAINSSTRINGEXACT
Empty image or helper icon

Sam McKay

CEO & Founder

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

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

Loading

Considerations when using the CONTAINSSTRINGEXACT?

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

Related Video Tutorials

Loading

Formula examples using the CONTAINSSTRINGEXACT

CONTAINSSTRINGEXACT(“abcd”, “bc”)

CONTAINSSTRINGEXACT(“abcd”, “BC”

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

[Case 1] [Case 2] [Case 3] [Case 4]
TRUE FALSE FALSE FALSE
Related Courses

Loading