Supported DAX Language Elements
Here you can find a list of client-side DAX language elements supported by AtScale.
info
Attention
Language elements that are not listed in this document are not supported.
Arithmetic operators and functions
- Operators: +-/*()=
- ABS
- ACOS, ACOSH, ACOT, ACOTH, ASIN, ASINH, ATAN, ATANH, COS, COSH, COT, COTH, SIN, SINH, TAN, TANH
- CONVERT
- CURRENCY
- DEGREES, RADIANS
- INT
- LOG, LOG10, LN
- MOD
- ODD
- PI, SQRT, DIVIDE
- POWER, EXP
- QUOTIENT
- RAND, RANDBETWEEN
- ROUND, CEILING, FLOOR, ISO.CEILING
- SIGN
- SQRTPI
- TRUNC
Directives
- DEFINE
- EVALUATE
- MEASURE
- ORDER BY
- VAR
Filter Functions
- ALL (only the table argument is supported)
- BLANK
- CALCULATE
- ISBLANK
Logical Functions
- AND
- COALESCE
- FALSE
- IF
- ISEMPTY
- ISSUBTOTAL
- NOT
- OR
- SWITCH
- TRUE
String Functions
- CONCATENATE
- EXACT
- LEN
- LOWER, UPPER
- MID, LEFT, RIGHT
- SEARCH
- TRIM
- Time Intelligence
- VALUE
Date and Time Functions
- DATE
- DAY
- HOUR
- MINUTE
- MONTH
- QUARTER
- SECOND
- TIME
- TODAY
- YEAR
Aggregation Functions
- AVERAGE
- MAX
- MIN
- SUM