Video - Solving Complex Business Problems with DAX

DAX (Data Analysis eXpressions) formulas are at the core of every analytical application, whether you use Microsoft Excel to create a PowerPivot workbook or Visual Studio to create Microsoft SQL Server Analysis Services tabular models. In this demo-heavy session, we dive deep into several more complex DAX solutions that will help you solve some common business problems like running totals, year-over-year comparison, sales predictions, 4-5-4 calendars, automatic time filters, and tool tables. In this level 400 session we take a look at what is actually happening inside the Power Pivot formula engine and how we get to the result, mostly looking at evaluation context.