powerquery - Multiple IF Statements in Power Query (PowerBI) "IfThenOtherwise" - Stack Overflow

admin管理员组

文章数量:1344519

I have a column called "CSI" listing different names formatted as "Last Name - First Name":

• Doe - John
• Sanders - Colonel
• Jackson - Michael

All three names above are part of Team 1 and all the remaining names are automatically considered being part of Team 2.

How do I add a new column indicating that the person is part of Team 1 or Team 2?

I tried the formulas below but failed: = if [CSI] = "Doe - John" then "Team 1" else if [CSI] = "Sanders - Colonel" then "Team 1" else if [CSI] = "Jackson - Michael" else "Team2"

= if [CSI] = #text(Doe - John) then "Team 1" else if [CSI] = #text(Sanders - Colonel) then "Team 1" else if [CSI] = #text(Jackson - Michael) else "Team2"

I have a column called "CSI" listing different names formatted as "Last Name - First Name":

• Doe - John
• Sanders - Colonel
• Jackson - Michael

All three names above are part of Team 1 and all the remaining names are automatically considered being part of Team 2.

How do I add a new column indicating that the person is part of Team 1 or Team 2?

I tried the formulas below but failed: = if [CSI] = "Doe - John" then "Team 1" else if [CSI] = "Sanders - Colonel" then "Team 1" else if [CSI] = "Jackson - Michael" else "Team2"

= if [CSI] = #text(Doe - John) then "Team 1" else if [CSI] = #text(Sanders - Colonel) then "Team 1" else if [CSI] = #text(Jackson - Michael) else "Team2"

• powerbi
• powerquery
• m

Share Improve this question Follow asked 7 hours ago Lio DjoLio Djo 15911 silver badge1212 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Multiple IFs are rarely a good idea, you could try the following:

= if List.Contains({"Doe - John", "Sanders - Colonel", "Jackson - Michael"}, [CSI]) 
  then "Team 1" 
  else "Team 2"

本文标签： powerqueryMultiple IF Statements in Power Query (PowerBI) quotIfThenOtherwisequotStack Overflow