Lookup using list of text

[rosemilo]

Hello Power BI Community,

I have 2 tables in my pbix file - 1 as the main source data, the other is the lookup values and correspoding category.

I want to return the "Category" Column to the main source by using "Standard Reason" Column as the look up values to main source data "Text line 4" Column.

Lookup Value

Main Source

So, if "Text line 4" contains words from the list of "Standard Reason", it will return the "Category".

Thank you in advance!

[rosemilo]

Thank you @tamerj1 ! It works!

[tamerj1 · Accepted solution]

Hi @rosemilo 

this a very similar case https://community.powerbi.com/t5/DAX-Commands-and-Tips/Convert-Excel-formula-to-DAX-Measure/m-p/2587...