Solved: DAX

kingrob01 · ‎02-17-2020

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 · ‎02-17-2020

Hi @kingrob01

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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Pragati11 · ‎02-17-2020

Hi @kingrob01 ,

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.

Best Regards,

Pragati Jain

LinkedIn | Twitter | Blog | YouTube

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!