Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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)
Proud to be a Super User!
you are welcome
Proud to be a 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)
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |