Forum Discussion
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...
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!
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
Awesome.