Search and return keyword from unrelated table

[llinasG]

Hi, I have two tables. 1st table contains column with text.

Table1[Text]

This item bought at Amazon

NETFLIX subscription charge

Monthly sibscription to Youtube premium

2nd Table contains keywords.

Table2 [keyword]

Amazon

NETFLIX

Youtube

I am looking for DAX solution to find a keyword in unrelated table amongst the text and return that keyword to the 1st table.

Like this

Text	Keyword
This item bought at Amazon	Amazon
NETFLIX subscription charge	NETFLIX
Monthly sibscription to Youtube premium	Youtube

This is the closest what I found, but solution is to return YES or NO value.

It says need to use CONCATENATEX et CALCULATETABLE  functions, but no idea how these could work.

https://community.fabric.microsoft.com/t5/Desktop/DAX-Search-value-in-unrelated-table/m-p/2554759#M9...

Would be great to have this resolved! Please.

[amitchandak · Accepted solution]

@llinasG , Try a new column in table 1

Column = Maxx(FILTER(T2,SEARCH(T2[Keywords],T1[Text],,0)>0), T2[Keywords])

[llinasG]

Great solution, thanks very much!!!