iii
Table of Contents
Foreword How Power Query Changed Our Lives .................................................................................. v
Chapter 0 Introducon: A New Revoluon ..........................................................................................1
Chapter 1 Imporng Basic Data .........................................................................................................11
Chapter 2 Overriding Power Query Defaults ......................................................................................19
Chapter 3 Basic Append Operaons ..................................................................................................27
Chapter 4 Imporng All Files in a Folder ............................................................................................33
Chapter 5 Aggregang Excel Worksheets ...........................................................................................43
Chapter 6 Unpivong Data ................................................................................................................51
Chapter 7 Imporng Nondelimited Text Files ..................................................................................... 57
Chapter 8 Imporng from Databases ................................................................................................. 65
Chapter 9 Merging Tables and Queries ..............................................................................................79
Chapter 10 Query Loading Desnaons .............................................................................................87
Chapter 11 Dening Data Types.........................................................................................................97
Chapter 12 Imporng Web Data ......................................................................................................103
Chapter 13 Loading Data from Exchange .........................................................................................111
Chapter 14 Grouping and Summarizing ...........................................................................................117
Chapter 15 Transposing and Unpivong Complex Data .................................................................... 123
Chapter 16 Automang Refreshing .................................................................................................. 133
Chapter 17 Power Query Formulas .................................................................................................. 139
Chapter 18 Condional Logic in Power Query .................................................................................. 153
Chapter 19 Power Query Objects ....................................................................................................157
Chapter 20 Understanding the M Language ..................................................................................... 173
Chapter 21 Creang Custom Funcons ............................................................................................189
Chapter 22 Advanced Condional Logic ...........................................................................................197
Chapter 23 Dynamic Parameter Tables ............................................................................................209
Chapter 24 Dynamic Calendar Tables ...............................................................................................215
Chapter 25 Query Organizaon .......................................................................................................221
Index ...............................................................................................................................................227
评论0