Header promotion in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows product names in the first column and their sales numbers in the second column. The first row contains the headers.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	200

Formula Trace

Table.PromoteHeaders(Source)

Step 1: Source

Step 2: Table.PromoteHeaders(Source)

Cell Reference Map

Product

↓

Apples

↓

Bananas

↓

Cherries

The formula uses the entire table starting at A1:B4. The first row (A1:B1) is promoted to headers.

Result

   Product   Sales
1  Apples    100
2  Bananas   150
3  Cherries  200

After header promotion, the first row becomes column headers. The data rows move up, so 'Apples' is now in row 1 under 'Product'.

Sheet Trace Quiz - 3 Questions

What does the Table.PromoteHeaders function do in this example?

A It deletes the first row.

B It sums the sales numbers.

C It turns the first row into column headers.

D It duplicates the first row.

Key Result

Table.PromoteHeaders shifts the first row to become column headers and moves data rows up.