Skip to main content
Version: I2023.3.0

Supported DAX Language Elements

Here you can find a list of client-side DAX language elements supported by AtScale. For more information on these elements, please refer to the Data Analysis Expressions (DAX) Reference documentation.

info

Attention

Language elements that are not listed in this document are not supported.

Functions

Aggregation Functions

  • AVERAGE
  • COUNT
  • DISTINCTCOUNT
  • MAX
  • MIN
  • SUM

Date and Time Functions

  • DATE
  • DAY
  • HOUR
  • MINUTE
  • MONTH
  • QUARTER
  • SECOND
  • TIME
  • TODAY
  • YEAR

Filter Functions

  • ALL
  • BLANK
  • CALCULATE
  • CALCULATETABLE
  • FILTER
  • ISBLANK
  • REMOVEFILTERS

Logical Functions

  • AND
  • COALESCE
  • FALSE
  • IF
  • ISEMPTY
  • ISSUBTOTAL
  • NOT
  • OR
  • SWITCH
  • TRUE

Math and trig functions

  • 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

Table Manipulation Functions

  • ADDCOLUMNS
  • SUMMARIZE
  • TOPN

Text Functions

  • CONCATENATE
  • EXACT
  • FORMAT
  • LEFT
  • LEN
  • LOWER
  • MID
  • RIGHT
  • SEARCH
  • TRIM
  • UPPER
  • VALUE

Statements

  • DEFINE
  • EVALUATE
  • MEASURE
  • ORDER BY
  • VAR

Operators

  • Arithmetic: + - / * () ^
  • Logical: IN
  • Comparison: = <> < > <= >=