DAX

DAX, aka Data analysis expressions, is a query language created in 2009.

#1250on PLDB

15Years Old

Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Power BI Desktop and SQL Server Analysis Services (SSAS) Tabular models. DAX includes some of the functions that are used in Excel formulas with additional functions that are designed to work with relational data and perform dynamic aggregation. It is, in part, an evolution of the Multidimensional Expression (MDX) language developed by Microsoft for Analysis Services multidimensional models (often called cubes) combined with Excel formula functions. Read more on Wikipedia...

DAX website
DAX Wikipedia page
DAX first developed in Microsoft
Monaco package for syntax highlighting DAX
See also: (1 related languages)Microsoft Excel

Example from the web:

EVALUATE
 ( FILTER ( 'DimProduct', [SafetyStockLevel] < 200 ) )
ORDER BY [EnglishProductName] ASC

DAX Keywords

VAR RETURN NOT EVALUATE DATATABLE ORDER BY START AT DEFINE MEASURE ASC DESC IN BOOLEAN DOUBLE INTEGER DATETIME CURRENCY STRING

Feature	Supported	Token	Example
Comments	✓		// A comment
MultiLine Comments	✓	/* */	/* A comment */
Line Comments	✓	//	// A comment
Strings	✓

DAX - Query language

Language features