Solving Complex Business Problems with DAX
Play 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.