CONTAINSSTRINGEXACT

Updated on
Rick de Groot

CONTAINSSTRINGEXACT is a DAX function that returns TRUE if one text string contains another text string, and it is case-sensitive.

Syntax

CONTAINSSTRINGEXACT(
   WithinText,
   FindText
)
Argument Properties Description
WithinText The text in which you want to search for FindText.
FindText The text you want to find. Wildcard characters are not allowed.

Return Values

TRUE if find_text is a substring of within_text; otherwise FALSE.

Remarks

CONTAINSSTRINGEXACT is case-sensitive.

Example

DAX query

EVALUATE
    ROW(
        "Case 1", CONTAINSSTRINGEXACT("abcd", "bc"), 
        "Case 2", CONTAINSSTRINGEXACT("abcd", "BC"),
        "Case 3", CONTAINSSTRINGEXACT("abcd", "a*d"),
        "Case 4", CONTAINSSTRINGEXACT("abcd", "ef")
    )

Returns

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

Other functions related to CONTAINSSTRINGEXACT are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/containsstringexact-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy