Forum Discussion

maalsan's avatar
maalsan
Advocate I
4 years ago
Solved

Find multiple substring DAX CONTAINSSTRING

Hello everyone,   I need to find if the substrings "house", "home", "dewelling" appear in a long string column. Using CONTAINSSTRING I am able to find each word at a time- house= CONTAINSSTRING(tab...
CONTAINSSTRING
find
string
Substring
Text
  • maalsan's avatar
    maalsan
    4 years ago

    That's weird. It still gives me an error message. 

    I found the solution to be simply:

    house= CONTAINSSTRING(table1[column1], "house" ) || CONTAINSSTRING(table1[column1], "home" ) || CONTAINSSTRING(table1[column1], "dewelling" )

     Without the need of IF statements. 

     

    Thanks!

RajaCSN's avatar
RajaCSN
Advocate II
4 years ago

Hi maalsan,

 

Assuming that you have table called "String" where Description is your column header; You have another table called Keyword, that contains a column header Keyword.

 

You can load both the tables to PowerBI and then for the String Table, you can create a calculated column as below:

 

 

Is this providing a solution for your query? If "yes" kindly confirm.

 

Request other experienced users to add value to my suggestion.

 

Best Regards,

 

C.S.N. Raja

 

 

Alexandernoclue's avatar
Alexandernoclue
Frequent Visitor
3 years ago

Hi Raja, im fascinated by your solution. Nevertheless I cant recreate it for myself.
The Search Process works fine, but my Result (when found) gives always ALL values from the Keyword list back.

The rootcause seems to be the "ResultwhenTrue" of the If statement.


EDIT: My Colleague found the problem. You cant have a active relation between the two tables. -.-