Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition

Index

Numerals and Symbols

2x2 levels of hierarchy, unpivoting tables with

complex tables, 149–151

dates, 146–149

3x3 levels of hierarchy, unpivoting tables with, 156

AdventureWorks example, 157–160

Column fields, 156–157

Row fields, 156–157

virtual PivotTables, 156–157

2018 Revenues query (Wide World Importers project), 380

, (comma), 70

& (concatenate) operator, 227, 231

{ } (curly brackets), 70, 226

= (equal) operator, 224, 227

=> (goes-to symbol), 171

<> (not-equal) operator, 224, 227

[ ] (square brackets), 230

.. (two dots) operator, 227

A

Access Web Content dialog box, 196, 200

Add Column tab (Power Query Editor), 11, 16

Add Conditional Column dialog box, 38–40, 44, 52, 98, 124–125, 208, 279–280, 285

Advanced Editor (Power Query Editor), ...