Power Query practice: Conditional Columns & Business Rules
Chapter 9 · 5 questions · included in full access
Question 1 · medium
Size bands with a Conditional Column
Solve it in your browserAdd Size: Qty ≥ 40 →
Bulk, Qty ≥ 15 →Standard, otherwiseSmall. Use Add Column ▸ Conditional Column with two rules and an Else.Question 2 · medium
if … then … else
Solve it in your browserAdd a custom column Priority:
Yeswhen Category is Sheets and Qty is 10 or more, otherwiseNo.Question 3 · easy
Add Column or Transform?
Solve it in your browserYou want the month name and want to keep the original date. Which tab do you use?
Question 4 · medium
Priority order classification
Solve it in your browserAdd Priority: return
"High"if Qty >= 30,"Medium"if Qty >= 15, and"Low"otherwise usingif ... then ... else.Question 5 · easy
Safe handling of missing notes
Solve it in your browserAdd CleanNotes: if Notes is
nullreturn"Standard", otherwise return the original Notes value.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing