Forum Discussion
Filter a table based on string values in another table
Hi everybody, Suppose I have the following table, "Table 1", that has a Serial Code column containing a string of text. I am trying to filter this table based on whether or not the Serial Code conta...
Anonymous , You can try a new column like
New column =
var _1 =countx( filter(Table2, search(Table2[Substrings], Table[Serial Code],,0)> 0),Table2[Substrings])
return
if(not(isblank(_1)),1, blank())
amitchandak
Super User
Super UserAnonymous , You can try a new column like
New column =
var _1 =countx( filter(Table2, search(Table2[Substrings], Table[Serial Code],,0)> 0),Table2[Substrings])
return
if(not(isblank(_1)),1, blank())
Thank you very much, amitchandak. This was a helpful suggestion!