Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX

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

DAX Query
  • az38's avatar
    az38
    6 years ago

    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's avatar
    Pragati11
    6 years ago

    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.

2 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    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.