Skip to main content
Version: I2023.2.0

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
  • COUNT
  • DISTINCTCOUNT
  • MAX
  • MIN
  • SUM