Supported Server-Side DAX Language Elements
Note
Server-side DAX language support is a Public Preview feature.
AtScale supports server-side DAX, providing an alternative to MDX for writing calculation expressions. This functionality helps streamline the process of converting Microsoft Power BI workbooks to AtScale models.
The following language elements are supported. For more information on these elements, refer to the Data Analysis Expressions (DAX) Reference in the Microsoft documentation.
Note
Language elements that are not listed in this document are not supported.
Functions
Aggregation functions
- AVERAGEA
- AVERAGEX
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- DISTINCTCOUNTNOBLANK
- MAXA
- MAXX
- MINA
- MINX
- PRODUCTX
- SUMX
Date and time functions
- DAY
- HOUR
- MINUTE
- MONTH
- QUARTER
- SECOND
- WEEKDAY
- WEEKNUM
- YEAR
Filter functions
- ALL
- ALLSELECTED
- CALCULATE
- CALCULATETABLE
- FILTER
- KEEPFILTERS
Logical functions
- AND
- COALESCE
- FALSE
- IF
- NOT
- OR
- SWITCH
- TRUE
Math functions
- ABS
- CEILING
- DIVIDE
- FLOOR
- INT
- LN
- LOG
- LOG10
- ROUND
Table functions
- ADDCOLUMNS
- SUMMARIZE
Text functions
- CONCATENATE
- LEFT
- MID
- RIGHT
- SUBSTITUTE
Time intelligence functions
- DATESMTD
- DATESQTD
- DATESYTD
Operators
Comparison operators
===><>=<=<>
Logical operators
&&||
Mathematical operators
+-*/^
Statements
- RETURN
- VAR