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

 

 

rusgesig's avatar
rusgesig
Helper IV
4 years ago

Brilliant scaleable solution. This way you only need to edit your keyword list and it will automatically update.