Forum Discussion
Solved
Trying to look up from another table based on array
I have a collumn with paragraphs (words) in one table and in a 2nd table I have a list of words in a collumn. I am trying to find a formula whereby DAX will look at all the words in the "paragraph" ...
hi Larry_USPS ,
try with SEARCH instead like:
match2 = IF( COUNTROWS( FILTER( table2, SEARCH(table2[words], Table1[paragraphs], 1, 0)>0 ) )>0, "Yes", "No" )SEARCH shall work in Power Pivot and i verified the code in Power BI:
Thanks Again, got an arror with the command "containsstring". Tried Contains(Strings) that didnt work either. THoughts? thanks again
FreemanZ
Super User
Super Userhi Larry_USPS ,
indeed there are some typo, please try this:
match =
IF(
COUNTROWS(
FILTER(
table2,
CONTAINSSTRING(Table1[paragraphs], table2[words])
)
)>0,
"Yes", "No"
)
it worked like:
Thanks for hanging with me and helping.. I think I found my issue, I am doing this in PowerPivot, not PowerBI, this the ContainsString isnt recoginized. Is there a way to do this within PowerPivot DAX commands ?
Thanks again
Larry
- FreemanZ
hi Larry_USPS ,
try with SEARCH instead like:
match2 = IF( COUNTROWS( FILTER( table2, SEARCH(table2[words], Table1[paragraphs], 1, 0)>0 ) )>0, "Yes", "No" )SEARCH shall work in Power Pivot and i verified the code in Power BI:
That Worked ! ... THANK YOU !! 🙏