Categorize text with keywords

[Anonymous]

Hi everyone,

Im using this formula to categorize text with keywords in excel: 

{=INDEX(categories,MATCH(TRUE,ISNUMBER(SEARCH(keywords,text)),0))}

To a better understanding of how its works: https://exceljet.net/formula/categorize-text-with-keywords

There is a way to do this in Power BI?

Best Regards

Gabriel Lopes

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Please check this post.

http://community.powerbi.com/t5/Desktop/Add-column-based-on-a-list-from-another-table/m-p/374238#M169934