Skip to main content
Version: I2024.2.x

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.

For more information on using DAX expressions in AtScale, see the AtScale Tabular Report Expression Examples document.

info

Attention

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

Functions​

Aggregation Functions​

  • AVERAGE
  • COUNT
  • COUNTX
  • DISTINCTCOUNT
  • MAX
  • MAXX
  • MIN
  • MINX
  • PRODUCTX
  • RANKX
  • SUM
  • SUMX

Date and Time Functions​

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

Filter Functions​

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

Logical Functions​

  • AND
  • COALESCE
  • FALSE
  • IF
  • IFERROR
  • 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
  • SUBSTITUTE
  • TRIM
  • UPPER
  • VALUE

Statements​

  • DEFINE
  • EVALUATE
  • MEASURE
  • ORDER BY
  • VAR

Operators​

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