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.
Please login or Register to submit your answer