Forum Discussion
Search for text from one table column in another table column and return a different column if found
I have seen some questions similar to this and I have tried some but they don't return what I want. I have one table that has a column with a program name. I have a second table that has a text f...
Anonymous , A new column in table 1
maxx(filter( Table2, search(Table1[Program Name], Table2[Assigned Program],,0) >0 ),Table2[LOB])
amitchandak
Super User
Super UserAnonymous , A new column in table 1
maxx(filter( Table2, search(Table1[Program Name], Table2[Assigned Program],,0) >0 ),Table2[LOB])
Thanks! If there are no records found by the Filer, will it give an error or is there a way to make it put 'None' in?