Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi,
take a look at your code, I think you have some typo:
1: "]" instead of "."
2: leading Blank
3: missing "["
Regards FrankAT
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
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.
Hi
Thanks for ur reply. where should i apply this DAX function..is there any option in the home Ribbons...
Thanks again
Kavitha
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |