Beginning DAX with Power BI

Introduction Goal: to set the scene and establish the context and background of the book Chapter 1: Understanding Calculated Columns, Measures, and Tables Goal: This chapter will explain the difference between Calculated Columns, Calculated Measures and Calculated Tables. 1.1 Calculated Columns 1.2 Calculated Measures 1.3 Calculated Tables 1.4 Mixing them up Chapter 2: Variables Goal: This chapter will explain variables and how they are used in DAX. 2.1 The VAR statement 2.2 Nested variables Chapter 3: Filter Context and calculations Goal: This chapter will explain filter context and the effect it has on DAX calculations 3.1 The ALL Statement 3.2 The ALLEXECPT statement 3.3 The ALLSELECTED statement Chapter 4: Summarizing and Aggregating Goal: This chapter will explain how to aggregate data using DAX using SQL examples 4.1 The SUMMARIZE statement< 4.2 MIN/MAX/SUM/AVG etc. 4.3 The SUMMARIZETABLE statements Chapter 5: Joining Tables Goal: This chapter will explain how to join tables in DAX using SQL examples 5.1 Single column join 5.2 Multi column joins 5.3 Left Joins 5.4 Inner Joins 5.5 Cross Joins Chapter 6: Optimizing Goal: This chapter will explain how to optimize your DAX 6.1 Query Plans 6.2 SQL Profiler 6.3 SQL Server Management Studio 6.4 DAX Studio Chapter 7: Troubleshooting Data Challenges with DAX Goal: This chapter will walk through some data challenges and how you might solve them using DAX 7.1 Using the CALENDARAUTO function as a numbers table 7.2 Adding Columns 7.3 Selecting Columns 7.4 Fun with dates 7.5 Expanding data