Power Query: condition column with multiple conditions but in order

[nic2023]

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! 

[lbendlin]

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

[nic2023 · Accepted solution]

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!