Forum Discussion
Switch Value to Text
I am trying to figure out how to create a new column that queries a word in column A and a word in column B and give a defined value. This needs to be able to do multiple words in each column to give a different value in new column.
Hello iamthearch,
Ah I see, it's just one table; there's no lookup table. You were close in your measure! Mine is below. The first main difference is the first parameter. I generally just set that to TRUE() because it's more intuitive to me. The second main difference is since you have multiple conditions, you have to combine them with an && into one condition; if you separate them with a comma, the SWITCH function thinks you're trying to move onto the next parameter. It only takes one condition, then the output to return, then another condition, then another output to return, etc.
Score = SWITCH ( TRUE(), Sheet1[I Need] = "Account Access" && Sheet1[Category] = "User Setup", 3, Sheet1[I Need] = "Account Access" && Sheet1[Category] = "Password Reset", 2 -- other values )Please let me know if you that works for you or if you were looking for something different. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
9 Replies
Hello iamthearch,
It'd probably be helpful for you to provide some concrete examples of what you're looking for here.
I am doing a dashboard for Service Desk reporting, I have the data output from our ticketing setup and I want to give a score to types of tickets. Example I want to take column A "I Need" and column B "Category" and match each value to get a score of 1-5 that is set in my values
I Need Category Score
Account Access User Setup 3
Account Access Password Reset 1
Hardware Laptop Repair 5
Hello,
So to confirm your situation, in your data model, you have:
- One table as output from the ticketing setup that has the "I Need" and "Category" columns (and other fields)
- A separate lookup table with three columns, including all the combinations of "I Need" and "Category" in the first two columns, and a third column of values that you want to be able to assign to individual tickets
And you want to be able to add a column to the first table, based on the appropriate value from the second table? Am I understanding correctly?