Forum Discussion

Helper III

4 years ago

Solved

Return Found Value in another Table

I have a list of "Keywords" (1 column table) that I'm using to find matches in a separate table on a free text field. The two tables do not have a relationship. I created the below column, which ...

Need Help

v-kkf-msft
4 years ago
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.
Return Found Value in another Table.pbix28 KB

v-kkf-msft

Community Support

4 years ago

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.

Return Found Value in another Table.pbix28 KB