topic Re: Lookup using list of text in DAX Commands and Tips

Lookup using list of text

Anonymous — Mon, 20 Jun 2022 16:39:29 GMT

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!

Re: Lookup using list of text

tamerj1 — Mon, 20 Jun 2022 16:46:07 GMT

Hi Anonymous

Re: Lookup using list of text

Anonymous — Wed, 22 Jun 2022 06:28:22 GMT

Thank you tamerj1 ! It works!