CONTAINSSTRING DAX Function (Information)
Returns TRUE if one text string contains another text string. CONTAINSSTRING is not case-sensitive, but it is accent-sensitive.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| WithinText |
The text in which you want to search for FindText. |
|
| FindText |
The text you want to find. You can use the ? and * wildcard characters; use ~? and ~* to find the ? and * characters. |
Return values
A value of TRUE if the string WithinText contains the string FindText – the comparison is not case-sensitive.
Related articles
Learn more about CONTAINSSTRING in the following articles:
-
From SQL to DAX: String Comparison
In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set of features you have in SQL, a few text comparison functions in DAX are only case-sensitive and others only case-insensitive,… » Read more
Related functions
Other related functions are:
Last update: Jan 11, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann
MSDN documentation: https://docs.microsoft.com/en-us/dax/containsstring-function-dax