Help with SWITCH function please

[Pricey79]

Hello, I was hoping someone could help me please.

I'm really struggling with something

I have a column in a table called Product. This has aorund 15 unique items in it.

I would like another column with a more generic Product description. So for example, if the product column had the choices BMX, Mountain or Racer, I would like a new column to say Bike, if the column product = BMX, Mountain or Racer

Could anybody please help with that, I'm really struggling.

Thank you in advance for any help.

[DataInsights · Accepted solution]

@Pricey79,

Try this calculated column:

Product Group = 
VAR vProduct = Table1[Product]
VAR vResult =
    SWITCH ( TRUE (), vProduct IN { "BMX", "Mountain", "Racer" }, "Bike", "Other" )
RETURN
    vResult