cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
armindom Frequent Visitor
Frequent Visitor

IF statement in PowerQuery (M) using values of 2 columns for a row ( Cant use AND)

Hi Everyone,

  I seem to be sleeping.. and strugling with something that should be fairly simple. I need to build a conditional column  that has to take in values dependent on a combination of existing values in 2 other colums

Column A        Column B   Column C
TM                       A              NOTOK
TM                       B               Super
TM                       C               Super
MS                       B                Nice
NB                       C                OK

In powerquery i can build

IF column A = MS then  Nice else if column A = NB then OK [ but i need here a combination of values: 
TM+B or TM+B = Super
TM+A= NOT OK

I can't seem to use "and" with or.. and it is late...maybe a hint will help


2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
edhans Super Contributor
Super Contributor

Re: IF statement in PowerQuery (M) using values of 2 columns for a row ( Cant use AND)

This will do all but the "NB" logic, but I think you'll get the idea. You most definitely can use "and" but you cannot use the conditional column builder to do it. You'll need to build your formula manually in a custom column.

 

= if [Column A] = "MS" then "Nice" 
     else if [Column A] = "TM" and ([Column B] = "B" or [Column B] = "C") then "Super"
     else if [Column A] = "TM" and [Column B] = "A" then "NOTOK"
     else null

View solution in original post

armindom Frequent Visitor
Frequent Visitor

Re: IF statement in PowerQuery (M) using values of 2 columns for a row ( Cant use AND)

Thanks... I will give it a try.. i hope this was just me sleepy 🙂

 

View solution in original post

2 REPLIES 2
Highlighted
edhans Super Contributor
Super Contributor

Re: IF statement in PowerQuery (M) using values of 2 columns for a row ( Cant use AND)

This will do all but the "NB" logic, but I think you'll get the idea. You most definitely can use "and" but you cannot use the conditional column builder to do it. You'll need to build your formula manually in a custom column.

 

= if [Column A] = "MS" then "Nice" 
     else if [Column A] = "TM" and ([Column B] = "B" or [Column B] = "C") then "Super"
     else if [Column A] = "TM" and [Column B] = "A" then "NOTOK"
     else null

View solution in original post

armindom Frequent Visitor
Frequent Visitor

Re: IF statement in PowerQuery (M) using values of 2 columns for a row ( Cant use AND)

Thanks... I will give it a try.. i hope this was just me sleepy 🙂

 

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)