Switch Value to Text

[Anonymous]

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.

[Wilson_]

Hello iamthearch,

It'd probably be helpful for you to provide some concrete examples of what you're looking for here.

[Anonymous]

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

[Wilson_]

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?

[Anonymous]

I want to be able to do something like this

Switch( Table[Column],

Sheet1[I Need]="Account Access", Sheet1[Category]="User Setup" , 3,

Sheet1[I Need]="Account Access", Sheet1[Category]="Password Reset", 2,

// Add other values

)

[Wilson_]

Given that I'm still trying to understand what your data model looks like, I think it would be more productive if we discussed this in plain English and not DAX. 😄

Is my understanding from my last post correct? If not, can you please provide a sample pbix file?

[Anonymous]

Is there an email that I can send you the PBIX File too

[Wilson_]

People tend to upload to dropbox or google drive, then share a link in their post. 🙂

[Anonymous]

Here is a link to my sample

https://5e11dac6-7715-4fa4-b090-8c8d198d2616.usrfiles.com/archives/5e11da_c103b12ecc6c4ace9c34ba0dfb...

[Wilson_ · Accepted solution]

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?)