How to write if then formula with multiple if conditions

[Anonymous]

Hi,

I am trying to write a DAX statement (my very first one) that does something like this - (just an example for ease of understanding)

If First Name is Kathy, Nickname is Kat

If First Name is Katherine, Nickname is Kat

If FIrst Name is Katrina, Nickname is Kat

Otherwise Nickname is Joe

I know how to do this:

Nickname = if('Users'[First Name]="Kathy", "Kat", "Joe")

However, I don't know how to get the additional name options in there that would also equal Kat.

Any help would be profoundly appreciated.

[Tahreem24 · Accepted solution]

@Anonymous You can try with Switch case:

COLUMN = SWITCH(TRUE(),

                     Table[NameColumn]="Kathy","Kat",
                     Table[NameColumn]="Theresa","Kat",

                     Table[NameColumn]="Fred","Kat",

                     "Joe"

                    )

[Anonymous]

Thank you for the hand-holding through my first question. I have fixed this.

[Tahreem24]

@Anonymous TRy this DAX:

COLUMN = If((LEFT(Name)=3)="Kat","Kat","Joe")

[Anonymous]

Hi Tahreem24, thank you for taking the time to answer. I really appreciate it. I was using that scenario as an example and I see I have mistakenly expressed my issue incorrectly because of the example I used. The point I meant to make was that I have three different if statements, that don't necessarily start with the same 3 letters. I meant to simplify the example, but only complicated it. My question is more like this:

If First Name is Kathy, Nickname is Kat

If First Name is Theresa, Nickname is Kat

If First Name is Fred, Nickname is Kat

Otherwise Nickname is Joe.

Otherwise Nickname is Joe

[Tahreem24 · Accepted solution]

@Anonymous You can try with Switch case:

COLUMN = SWITCH(TRUE(),

                     Table[NameColumn]="Kathy","Kat",
                     Table[NameColumn]="Theresa","Kat",

                     Table[NameColumn]="Fred","Kat",

                     "Joe"

                    )

[Anonymous · Accepted solution]

Yes! Thank you. I believe this is what I needed. 😀

[Tahreem24]

@Anonymous I am glad that your issue has been solved. But you mistakenly marked your reply as a solution. Kindly properly mark right reply as a solution which will help others also.