Description
Book SynopsisLearn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI-Microsoft''s leading self-service business intelligence application-and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks.
Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. You will learn how Power BI, through combining DAX building blocks (such as measures, table filtering, and data lineage), can yield extraordinary analytical power. Throughout
Table of Contents
Part I: The Foundation
Chapter 1: DAX Mechanic
Chapter 2: Data Modeling
Chapter 3: DAX Lineage
Part II: Core Concepts
Chapter 4: This Weird Context Thing
Chapter 5: Filtering in DAX
Chapter 6: Iterators
Chapter 7: Filters Using Measures
Part III: DAX to Solve Advanced Everyday Problems
Chapter 8: Using DAX to Solve Advanced Reporting Requirements
Chapter 9: Time Intelligence
Chapter 10: Finding What's Not There
Chapter 11: Row Level Security
Part IV: Debugging and Optimization
Chapter 12: DAX Studio
Chapter 13: Query Plans
Chapter 14: Scale your Models
