Forum Discussion
How to create custom column with multiple ''IF'' ''AND'' ''THEN''
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
5 Replies
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.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.
Hi,
take a look at your code, I think you have some typo:
1: "]" instead of "."
2: leading Blank
3: missing "["
Regards FrankAT
