Chapter 4. Introducing calculations in DAX

Now that you have seen the basics of the SQL Server Analysis Services (SSAS) tabular model, it is time to learn the fundamentals of Data Analysis Expressions (DAX). DAX has its own syntax for defining calculation expressions. It is somewhat similar to a Microsoft Excel expression, but it has specific functions that enable you to create more advanced calculations on data that is stored in multiple tables.

The goal of this chapter is to provide an overview of the main concepts of DAX without pretending to explain in detail all the implications of every feature and function in this language. If you want to learn DAX, we suggest reading our book, The Definitive Guide to DAX, published by Microsoft Press. ...

Get Tabular Modeling in Microsoft SQL Server Analysis Services, Second Edition 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.