Part V: Understanding Power Pivot and Power Query
FIGURE 40.4
All of the query steps before Grouped Rows are needed to prepare the data for grouping.
You could always start from step 1 and import another copy of the source data, but
you’d have to repeat the preparation steps (the Filtered Rows and Merged Columns
steps in this case).
A better way is to reuse the steps you’ve already created by extracting them into a
new query. The idea is first to decide what steps you want to reuse and then right-
click the step immediately below. In this scenario (see Figure 40.4), you want to
keep all query steps up until Grouped Rows.
- Right-click the Grouped Rows step and select Extract Previous.
- Use the Extract Steps dialog box shown in Figure 40.5 to name the new query
SalesByBusiness. Click OK to confirm.
FIGURE 40.5
Naming the new query SalesByBusiness
