Chapter 7 Exercise 7-1 Promoted Headers and Changed Types steps should be removed

Book Q&ACategory: Chapter 7Chapter 7 Exercise 7-1 Promoted Headers and Changed Types steps should be removed
Gil Raviv Staff asked 8 months ago

I am not sure I can follow Exercise 7-1 correctly.

What am I doing wrong?

1 Answers
Best Answer
Gil Raviv Staff answered 8 months ago

Due to the extra Promoted Headers step in Power Query that was introduced by Microsoft after the book was written, you should remove the auto-generated Promoted Headers and Changed Type steps in Applied Steps before you proceed to step 5. Here is the correct step:

Step 4. In the Navigator dialog box, select Revenues and then select Edit.

When the Power Query Editor opens, delete the last two steps, Promoted Headers and Changed Type in Applied Steps. You can visualize in your mind the virtual PivotTable Row fields and Column fields: The Row fields are Country, State/Region, and City. The Column fields are Color, Parent Category, and Category. We will refer to the letter N as the number of Row fields; in this case, N=3. We will refer to the letter M as the number of Column fields; in this case, M=3.