Index

Numerals and Symbols

2x2 levels of hierarchy, unpivoting tables with

complex tables, 149151

dates, 146149

3x3 levels of hierarchy, unpivoting tables with, 156

AdventureWorks example, 157160

Column fields, 156157

Row fields, 156157

virtual PivotTables, 156157

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, 3840, 44, 52, 98, 124125, 208, 279280, 285

Advanced Editor (Power Query Editor), ...

Get Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.