Forum Discussion

enzos's avatar
enzos
Frequent Visitor
5 years ago

Search for specific text values from a dictionary column

Hi, I'm trying to recreate an excel report to PBI. What i am having troubles recreating is the dictionary table which allows us to search for an specific keyphrase in Table A and categorize them into...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi enzos,

I'd like to suggest you take a look at the following blog about string Comparison in power bi DAX expressions:

From SQL to DAX: String Comparison 

Regards,
Xiaoxin Sheng

enzos's avatar
enzos
Frequent Visitor
5 years ago

Hi,

 

I read through the article but sadly i coudlnt find something that could help, what im looking for is a way to search a column against another column, and if it finds a match to then give me the corresponding category.

 

I am looking for a way to find a keyphrase from table dictionary in column description from Table A, and if there is a match with one of the keyphrases to match it and pull the corresponding category.

 

I could create multiple columns that each search for a keyphrase but as we add more and more keyphrases that would be inefficient.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI enzos,

    According to your description, I think you may need 'machine learning' or AI insight to recognize and analyze your table records instead of manually checking and replace text with DAX formula. You can take a look at the following document to know more about these:

    Use AI Insights in Power BI Desktop 

    Regards,

    Xiaoxin Sheng