Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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- Fill in a new custom column for the ticket category it will fall under
Example: If a keyword for "login" is found -> Custom column will be "Login Issue/Request"
The only solution i found was to make a conditional column for this. But unfortunately since there are a lot of keywords, I have a lot of else-if conditions to make. This is what my DAX formula looks like:
Is there a more dynamic way to do it in DAX? Or I can just stick to how I'm currently doing it?
Thanks for your help in advance! 🙂
Solved! Go to Solution.
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
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
Hi Xiaoxin,
Thank you!!! I was able to create a new column with these formula:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |