DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Connecting to AtScale From Business-Intelligence SoftwareConnecting with Microsoft Power BIUsing DAX TabularSupported DAX Language Elements

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.

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
  • 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: = <> < > <= >=