DAX

Hi Anonymous 

you've got an exessive last common ","

anyway, you can try to do it more easy

Weight = SWITCH ( 'AI'[quest],
"California", 6,
"Nebraska", 3,
"Florida", 10,
"Texas", 8,
"Georgia",3,
"Newyork", 10,
"Maryland", 4,
"Ohio", 8,
"Alabama", 10,
"Undefined"
)

Hi Anonymous ,

In your DAX expression, you have got an extra "," in the end. Just remove it and use the following:

Weight = SWITCH ( TRUE(),
'AI'[quest] = "California", 6,
'AI'[quest] = "Nebraska", 3,
'AI'[quest] = "Florida", 10,
'AI'[quest] = "Texas", 8,
'AI'[quest] = "Georgia",3,
'AI'[quest] = "Newyork", 10,
'AI'[quest] = "Maryland", 4,
'AI'[quest] = "Ohio", 8,
'AI'[quest] = "Alabama", 10
)

This will work.

Thanks.