Column operations (rename, remove, reorder) in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows products with their IDs, names, categories, and prices.

Cell	Value
A1	ProductID
B1	ProductName
C1	Category
D1	Price
A2	101
B2	Pen
C2	Stationery
D2	1.5
A3	102
B3	Notebook
C3	Stationery
D3	3.0
A4	103
B4	Mug
C4	Kitchen
D4	5.0

Formula Trace

Table.RenameColumns(Table.RemoveColumns(Table.ReorderColumns(Source, {"ProductName", "Category", "Price", "ProductID"}), {"ProductID"}), {{"ProductName", "ItemName"}})

Step 1: Table.ReorderColumns(Source, {"ProductName", "Category", "Price", "ProductID"})

Step 2: Table.RemoveColumns(step1_result, {"ProductID"})

Step 3: Table.RenameColumns(step2_result, {{"ProductName", "ItemName"}})

Cell Reference Map

    A          B           C         D
1 ProductID  ProductName  Category  Price
2    101        Pen    Stationery    1.5
3    102    Notebook    Stationery    3.0
4    103        Mug      Kitchen     5.0

Arrows:
Source columns: A1:D4
Reorder uses B1, C1, D1, A1
Remove uses A1
Rename uses B1

The formula uses columns ProductName (B), Category (C), Price (D), ProductID (A) for reorder; removes ProductID (A); renames ProductName (B) to ItemName.

Result

    A         B          C
1 ItemName  Category   Price
2 Pen       Stationery  1.5
3 Notebook  Stationery  3.0
4 Mug       Kitchen    5.0

The final table shows columns reordered to ItemName (renamed from ProductName), Category, and Price. ProductID is removed.

Sheet Trace Quiz - 3 Questions

Which column is removed in the formula?

A Category

B ProductID

C Price

D ProductName

Key Result

Reorder columns, then remove unwanted columns, then rename columns as needed.