Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Categorize text with keywords

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