CONTAINSSTRING, CONTAINSSTRINGEXACT – finds text string in another text string (DAX – Power Pivot, Power BI)
CONTAINSSTRING is a function, verifying, whether there is some textstring. CONTAINSSTRINGEXACT works similarly but is case sensitive.
It is simple. If there is “small pink pig” in column Item, then this:
- Contains pig = CONTAINSSTRING(List1[Animal];"pig")
returns True. On the other hand this:
- Contains frog = CONTAINSSTRING(List1[Animal];"frog")
These functions are quite missing in Excel (outside DAX), where have to be replaced by complicated combination like: