Dax Statement Help - Multiple IF Statements

[irnm8dn]

In my dataset, I have a column with multiple text values.  I am looking for assistance with a DAX statement that will allow me to change the values (in a new column) to something more description.  For instance:

If B = Blue, If R=Red, If Y = Yellow

I am having problems creating mutliple conditions and have Power BI accept the statement.

Thanks in advance for the help!

[vanessafvg]

@irnm8dn

column = switch(fieldname,

                           "b", "Blue",

                          "r", "red")

etc

[irnm8dn]

Thanks @vanessafvg

Hate to be so literal, but can you write the exact dax statement?

[vanessafvg]

@irnm8dn

whats your field name?

[vanessafvg · Accepted solution]

@irnm8dn

New Column = 

Switch (Position[Formal]),

"B", "Blue",

"R", "Red",

"Y", "Yellow",

"Other")

[irnm8dn]

Position (Formal)

Will this be a new column, or change the existing?