Forum Discussion

AndyPBI's avatar
AndyPBI
New Member
2 years ago
Solved

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] = "...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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)

     

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

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)