Chapter 1. What is DAX?

DAX is the programming language of Microsoft SQL Server Analysis Services (SSAS) and Microsoft Power Pivot for Excel. It was created in 2010, with the first release of PowerPivot for Excel 2010 (yes, in 2010 PowerPivot was spelled without the space; the space was introduced in the Power Pivot name in 2013). Over time, DAX gained popularity in the Excel community, which uses DAX to create Power Pivot data models in Excel, and in the Business Intelligence (BI) community, which uses DAX to build models with SSAS.

DAX is a simple language. That said, DAX is different from most programming languages and it might take some time to become acquainted with it. In our experience, having taught DAX to thousands of people, learning ...

Get The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.