Excel 2019 Bible

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.27 Use the Data Type drop-down to discover and select the data type ...

Part V: Understanding Power Pivot and Power Query Next, find the CompanyNumber column in the Available Columns list and double- ...

Chapter 39: Transforming Data with Power Query 39 Table 39.2 lists some other Power Query functions useful in extending the capa ...

Part V: Understanding Power Pivot and Power Query This function tells Power Query to evaluate the [2016 Potential Revenue] field ...

Chapter 39: Transforming Data with Power Query 39 Power Query offers a Group By feature that enables you easily group to data an ...

Part V: Understanding Power Pivot and Power Query Use the Operation drop-down list to select the kind of aggregation you want t ...

887 C H A P T E R 40 Making Queries Work Together IN THIS CHAPTER Reusing query steps Consolidating data with the Append feature ...

Part V: Understanding Power Pivot and Power Query FIGURE 40.1 This data can be used as the source for various levels of aggregat ...

Chapter 40: Making Queries Work Together 4040 FIGURE 40.2 Merge the Last_Name and First_Name columns to create a new Employee fi ...

Part V: Understanding Power Pivot and Power Query FIGURE 40.4 All of the query steps before Grouped Rows are needed to prepare t ...

Chapter 40: Making Queries Work Together 4040 After clicking OK, Power Query does two things. First, it moves all the extracted ...

Part V: Understanding Power Pivot and Power Query The Append feature comes in handy when you need to consolidate multiple identi ...

Chapter 40: Making Queries Work Together 4040 Now, because you’re creating this query simply for the purpose of appending it to ...

Part V: Understanding Power Pivot and Power Query FIGURE 40.9 Appending multiple queries to NorthData Choose the Three or more ...

Chapter 40: Making Queries Work Together 4040 FIGURE 40.10 The final consolidated table of all regional data Note in Figure 40.9 ...

Part V: Understanding Power Pivot and Power Query Understanding the Merge Feature You’ll often find the need to build queries th ...

Chapter 40: Making Queries Work Together 4040 Full Outer This join tells Power Query to return all of the records from both quer ...

Part V: Understanding Power Pivot and Power Query FIGURE 40.13 Activating the Merge dialog box Figure 40.14 illustrates the Merg ...

Chapter 40: Making Queries Work Together 4040 FIGURE 40.14 The completed Merge dialog box At the bottom of the Merge dialog box, ...

Part V: Understanding Power Pivot and Power Query FIGURE 40.15 Expand the NewColumn field, and choose the merged fields you want ...