Forum Discussion
Return Found Value in another Table
Hi astano05 ,
Please try the following measure:
Keyword Search Return Name = VAR tab = ADDCOLUMNS ( CROSSJOIN ( VALUES ( DataNew[Name] ), VALUES ( Keywords[Keyword] ) ), "find", SEARCH ( [Keyword], [Name], 1, 0 ) ) RETURN MAXX ( FILTER ( tab, [find] > 0 ), [Keyword] )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This doesn't work. The lookup that I need is approximate. I am trying to replicate a fuzzy lookup. The below formula I have works to give a yes/no for an approximate look up to a list, but I want it to return which value matched instead of "Yes"
IF(
SUMX(ContractorKeywords,
FIND(
UPPER(ContractorKeywords[Contractor Keyword]),
UPPER(DataNew[CONTRACTOR])
,,0
)
) > 0,
"Yes",
"No"
)Hi astano05 ,
Please try the following measure:
Keyword Search Return Name =
VAR tab =
ADDCOLUMNS (
CROSSJOIN ( VALUES ( DataNew[Name] ), VALUES ( Keywords[Keyword] ) ),
"find", SEARCH ( [Keyword], [Name], 1, 0 )
)
RETURN
MAXX ( FILTER ( tab, [find] > 0 ), [Keyword] )
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This works perfectly! thank you