Table of Contents

Chapter 1: Show Me the Data.- Chapter 2: DAX Objects, Syntax & Formatting.- Chapter 3: Calculated Columns & Measures.- Chapter 4: Evaluation Context.- Chapter 5: Iterators.- Chapter 6: The CALCULATE Function.- Chapter 7: DAX Table Functions.- Chapter 8: The ALL Function and All its Variations.- Chapter 9: Calculations on Dates: Using DAX Time Intelligence.- Chapter 10: Empty Values Versus Zero.- Chapter 11: Using Variables: Making Our Code More Readable.- Chapter 12: Returning Values in the Current Filter.- Chapter 13: Controlling the Direction of Filter Propagation.- Chapter 14: Working with Multiple Relationships Between Tables.- Chapter 15: Understanding Context Transition.- Chapter 16: Leveraging Context Transition.- Chapter 17: Virtual Relationships: the LOOKUPVALUE and TREATAS Functions.- Chapter 18: Table Expansion.- Chapter 19: The CALCULATETABLE Function.

About the Author

Alison Box is Director of Burningsuit Ltd, and an IT trainer and consultant with over 30 years of experience delivering computer applications training to all skill levels, from basic users to advanced technical experts.  Currently, she specializes in delivering training in Microsoft Power BI Service and Desktop, Data Modeling, DAX (Data Analysis Expressions), and Excel. Alison also works with organizations as a DAX and Data Analysis consultant. She was one of the first Excel trainers to move into delivering courses in Power Pivot and DAX, from where Power BI was born. Part of her job entails promoting Burningsuit as a knowledge base for Power BI and includes writing regular blog posts on all aspects of Power BI that are published on her website.