The definitive guide to DAX: business intelligence with Microsoft Excel, SQL Server analysis services and Power BI

Description

What is DAX? -- Introducing DAX -- Using basic table functions -- Understanding evaluation contexts -- Understanding Calculate and Calculatetable -- DAX examples -- Time intelligence calculations -- Statistical functions -- Advanced table functions -- Advanced evaluation context -- Handling hierarchies -- Advanced relationships -- The VertiPaq engine -- Optimizing data models -- Analyzing DAX query plans -- Optimizing DAX.;This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX's remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need.-- What is DAX? -- Introducing DAX -- Using basic table functions -- Understanding evaluation contexts -- Understanding Calculate and Calculatetable -- DAX examples -- Time intelligence calculations -- Statistical functions -- Advanced table functions -- Advanced evaluation context -- Handling hierarchies -- Advanced relationships -- The VertiPaq engine -- Optimizing data models -- Analyzing DAX query plans -- Optimizing DAX.