DAX

[Anonymous]

I'm trying to create a column that assigns a value based on following table.  Getting DAX error.  If I reference AI table and location is x then value is value. Any help would be greatly appreciated.  

AI Table       Quest          New Ideal Column 
AI Record    Location       Weight Value

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

[az38 · Accepted solution]

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

[Pragati11 · Accepted solution]

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.

[az38 · Accepted solution]

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