Data Analysis eXpression, calculated columns, and measures
Data Analysis eXpression (DAX) is a query language for tabular models of Microsoft, such as PowerPivot and SSAS Tabular. DAX was introduced in 2010 with PowerPivot and enhanced in SSAS Tabular 2012. The structure of a DAX command is very simple, but a number of built-in functions in DAX is enough to create complex expressions to answer business requirements.
DAX is the language used for creating calculated columns and measures. As you saw in the previous sections, calculated columns are columns added in each table. The value of the calculated columns will be calculated at the time of processing and will be stored in memory. Measures also use DAX expressions for calculations. Measures will ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide 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.
