Assistance needed with formula for new column in Power BI

[richleeb2]

I want to create a 3rd column (New Name) with revised names for Test 1 in Name column.  For Test1, I want this to be named Test A IF Basket column is equal to xray1 or xray2.  But if the Basket is qual1 or qual 2, I want the new name to be Test B.  I want to keep the Test2 name the same.  Can you help with the formula?  Thanks!

Name	Basket	New Name
Test1	xray1	TestA
Test2	bob	Test2
Test1	xray2	TestA
Test2	bob	Test2
Test1	qual1	TestB
Test2	bob	Test2
Test1	qual2	TestB
Test2	bob	Test2

[ChrisMendoza]

Try as:

Column = 
SWITCH(
    TRUE(),
    LEFT(TableName[Basket],4) = "xray", "TestA",
    LEFT(TableName[Basket],4) = "qual", "TestB",
    TableName[Name]
)

[richleeb2]

I tried this but got "Function 'SWITCH' does not support comparing values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values."  What does the 4 do?  

[ChrisMendoza]

So your sample was not representative (data types) of your actual data? My guess is try:

Column = 
SWITCH(
    TRUE(),
    LEFT(TableName[Basket],4) = "xray", "TestA",
    LEFT(TableName[Basket],4) = "qual", "TestB",
    VALUE(TableName[Name])
)

 or maybe this:

Column = 
SWITCH(
    TRUE(),
    LEFT(VALUE(TableName[Basket]),4) = "xray", "TestA",
    LEFT(VALUE(TableName[Basket]),4) = "qual", "TestB",
    TableName[Name]
)

or all of both of them combined.

[ChrisMendoza · Accepted solution]

Could also be:

Column = 
SWITCH(
    TRUE(),
    LEFT(TableName[Basket],4) = "xray", "TestA",
    LEFT(TableName[Basket],4) = "qual", "TestB",
    FORMAT(TableName[Name],"0")
)

It's really hard for me to know what data types you're dealing with if they are not in your sample.

[richleeb2]

THe first one worked, I just changed the number to the actual length of the word.  Thanks!