Power Query practice: Index Columns & Row Sequences
Chapter 11 · 5 questions · included in full access
Question 1 · easy
Number the rows
Solve it in your browserAdd an Index column starting at 1: Add Column ▸ Index Column ▸ From 1.
Question 2 · easy
0-based versus 1-based index
Solve it in your browserWhy would a data analyst choose a 1-based index over a 0-based index in Power Query?
Question 3 · easy
Zero-based row offset index
Solve it in your browserAdd a zero-based index column RowZero starting at
0and incrementing by1usingTable.AddIndexColumn.Question 4 · medium
Batch tracking sequence
Solve it in your browserAdd BatchID: generate an index starting at
100with a step increment of5usingTable.AddIndexColumn.Question 5 · medium
Preserve arrival sequence before sort
Solve it in your browserAdd ArrivalOrder (1-based index), then sort by Qty descending using
Table.Sort.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing