Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
AndyPBI
New Member

Need help with Power Query Add Column using multiple conditions

Hello, and thank you for reading:

There are 2 conditions that need to be met, for an end result.

 

if [priority] = "1 - Critical" and [major_incident] = "TRUE"
then "P1"
else if [priority] = "1 - Critical" and [major_incident] = "FALSE"
then "P5"
else null

 

My second statement "else if" overrides the first statement. What am I doing wrong?

More detail:

I ran the first statement alone, and it works as expected. It gives me the end result of "P1". However, when I run both the statements it replaces every row with "null" - and ignores the fact that the conditions for the first statement WERE met, but didn't reflect in my data.

 

How do I change my query to accomodate the first statement? 

Even more detail if needed:

This question will be called a success if I can accomplish the end goal of:
If a P1 is accompanied by a TRUE Major incident = P1
If a P1 is accompanied by a FALSE Major incident = P5


If a P2 is accompanied by a TRUE Major incident = P2

If a P2 is accompanied by a FALSE Major incident = P5. 

So on, so forth... all the way to a P4. And it has to be done all within 1 custom conditional column with 1 query. 
ANY time "major incident" is False, the end result must be "P5" 

Thank you for reading!! Any help here would be appreciated. I feel like I am very close but I have ran out of ideas.

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

pls try to change true and false to lower case.

 

= Table.AddColumn(#"Changed Type", "Custom", each if [priority]="1 - Critical" and [major_incident] =true then "p1" else if [priority]="1 - Critical" and [major_incident] =false then "p5" else null)

 

11.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
AndyPBI
New Member

Wow, well that was easy. THANK YOU SO MUCH!!!! @ryan_mayu 

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

pls try to change true and false to lower case.

 

= Table.AddColumn(#"Changed Type", "Custom", each if [priority]="1 - Critical" and [major_incident] =true then "p1" else if [priority]="1 - Critical" and [major_incident] =false then "p5" else null)

 

11.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors