Using SWITCH function to change the values of column to new values and getting this below error,

[Sharma0815]

SWITCH(Table1[Queue],"CSC EZTech" || "CSC ", Programming Support","Engine","Duty","I6Engine","Medium","Other")

I have blanks in Queue column,I'm not sure if blank values causing this error.

Error:

Function 'SWITCH' does not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.

[Greg_Deckler]

Maybe try:

SWITCH(Table1[Queue] & "","CSC EZTech" || "CSC ", Programming Support","Engine","Duty","I6Engine","Medium","Other")

[Sharma0815]

Thanks @Greg_Deckler ,Tried and  still getting the same error 

SWITCH(Table1[Queue] & "","CSC EZTech" || "CSC ", Programming Support","Engine","Duty","I6Engine","Medium","Other")

Function 'SWITCH' does not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.

[Greg_Deckler · Accepted solution]

OK, let's figure out what is going on here, try this:

SWITCH(TRUE(),
  Table1[Queue] = "CSC EZTech" || Table1[Queue] = "CSC ", "Programming Support",
  Table1[Queue] = "Engine","Duty",
  Table1[Queue] = "I6Engine","Medium",
  "Other"
)

[Sharma0815]

This one worked for me ,Thanks alot @Greg_Deckler 

SWITCH(TRUE(), Table1[Queue] = "CSC EZTech" || Table1[Queue] = "CSC ", "Programming Support", Table1[Queue] = "Engine","Duty", Table1[Queue] = "I6Engine","Medium", "Other" ) 

[Greg_Deckler]

Cool, OK, so the issue is that SWITCH didn't like specifying a column value to switch on and then coupled with a logical true/false statement. Makes sense.

[Greg_Deckler]

Or maybe this:

SWITCH(Table1[Queue]
  "CSC EZTech","Programming Support",
  "CSC ","Programming Support",
  "Engine","Duty",
  "I6Engine","Medium",
  "Other"
)