How to create custom column with multiple ''IF'' ''AND'' ''THEN''

[Anonymous]

Hi

How to create custom column with multiple ''IF'' ''AND'' ''THEN'' statements in power query.

i am trying to write this formula in query editor.

if [PLANTS]="DDDD” and [PLANTS1]="MUMBAI" then "A"

else if [PLANTS.<>"DDDD" and [PLANTS1]="MUMBAI" and [CODE]=" PARTS" then "B"

else if PLANTS]<>"DDDD" and [PLANTS1]="MUMBAI" and [CODE]<>"PARTS1" then "C"

Kindly guide.

Thanks

Kavitha

[FrankAT]

Hi,

take a look at your code, I think you have some typo:

1: "]" instead of "."

2: leading Blank

3: missing "["

Regards FrankAT

[Anonymous]

Hi FrankAT

This one is sample formula..i used this in excel query table.now i want to use the same formule in query table..is this possible in custom column with multiple ''if''''and '' statements.

Thanks

Kavitha

[Anonymous]

USE SWITCH() FUNCTION

https://docs.microsoft.com/en-us/dax/switch-function-dax

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Hi

Thanks for ur reply. where should i apply this DAX function..is there any option in the home Ribbons...

Thanks again

Kavitha

[Anonymous]

you can not have home ribbons for and conditions.

You can simply write same formull if this then this. but it will make your code little bit complex.

Simply use switch(). if you are ok with if then write it like below

new column= if([PLANTS]="DDDD” &&[PLANTS1]="MUMBAI","A", if([PLANTS]<>"DDDD” && [PLANTS1]="MUMBAI","B",

if([PLANTS]<>"DDDD” && [PLANTS1]<>"MUMBAI","C")))

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.