Contents at a Glance
Foreword xvii
Introduction to the second edition xx
Introduction to the fi rst edition xxi
CHAPTER 1 What is DAX? 1
CHAPTER 2 Introducing DAX 17
CHAPTER 3 Using basic table functions 57
CHAPTER 4 Understanding evaluation contexts 79
CHAPTER 5 Understanding CALCULATE and CALCULATETABLE 115
CHAPTER 6 Variables 175
CHAPTER 7 Working with iterators and with CALCULATE 187
CHAPTER 8 Time intelligence calculations 217
CHAPTER 9 Calculation groups 279
CHAPTER 10 Working with the fi lter context 313
CHAPTER 11 Handling hierarchies 345
CHAPTER 12 Working with tables 363
CHAPTER 13 Authoring queries 395
CHAPTER 14 Advanced DAX concepts 437
CHAPTER 15 Advanced relationships 471
CHAPTER 16 Advanced calculations in DAX 519
CHAPTER 17 The DAX engines 545
CHAPTER 18 Optimizing VertiPaq 579
CHAPTER 19 Analyzing DAX query plans 609
CHAPTER 20 Optimizing DAX 657
Index 711