Forum Discussion

nic2023's avatar
nic2023
Frequent Visitor
2 years ago
Solved

Power Query: condition column with multiple conditions but in order

Would like to get some advice on: 

How to set up a new condition colcumn ("Tag") to meet the following 4 conditions in order - step 1 to 4: 

Step1 : Filter "Project ID" beging with "WR", anything not begin with WR tag as "n/a"
Step2: Filter "Cost Centre" = 22000 then Tag = Work Request
Step 3: After filter out Cost Cenre 22000, then filter "Region" = US, then Tag = RUN
Step 4: After filter out US, then filter "Region" =Non-US, then Tag = Change

 

Thank you so much guys! 

Need Help
  • nic2023's avatar
    nic2023
    2 years ago

    Thanks! 

    I've figured out it. Managed to set up those conditions in Custom Columns by using "else if" - worked out perfectly. 🙂 

    Thank you all the same! 

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    That's a great summary.  You can implement that verbatim.  What have you tried and where are you stuck?

    • nic2023's avatar
      nic2023
      Frequent Visitor
      2 years ago

      Thanks! 

      I've figured out it. Managed to set up those conditions in Custom Columns by using "else if" - worked out perfectly. 🙂 

      Thank you all the same!