Forum Discussion

annlois's avatar
annlois
Frequent Visitor
3 years ago
Solved

Column Text Analysis via Keyword Search

I'm currently trying to make a ticket pattern analysis from 3 different columns. What I'm trying to do: 1- Search keywords of "Login issues" / "access request" etc etc on 3 different columns 2- Fi...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI annlois,

    You can create a new table with keywords and correspond status.(e.g. Keyword, Status) Then you can use Dax expression add the calculated column in your table to look up the custom table records with current table fields values to output the result status.

    If you are confused about coding formula, please share dummy data dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI annlois,

You can create a new table with keywords and correspond status.(e.g. Keyword, Status) Then you can use Dax expression add the calculated column in your table to look up the custom table records with current table fields values to output the result status.

If you are confused about coding formula, please share dummy data dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

annlois's avatar
annlois
Frequent Visitor
3 years ago

Hi Xiaoxin,

Thank you!!! I was able to create a new column with these formula:

Column1= MAXX(filter(ALL(TableA), CONTAINSSTRING([TableB.Resolution], TableA[Column1])),TableA[Column2])
 
Now I need to fill in my fields with not only the comparison from TableB.Resolution, but also with other tableB columns like TableB.Description and TableB.DetailedDescription. Maybe you have a hint how I can do it? 🙂