Skip to main content

Server-Side DAX Reference

Note

Server-side DAX language support is a Public Preview feature.

AtScale supports server-side DAX, providing an alternative to MDX for writing calculation expressions. This functionality helps streamline the process of converting Microsoft Power BI workbooks to AtScale models.

The following language elements are supported. For more information on these elements, refer to the Data Analysis Expressions (DAX) Reference in the Microsoft documentation.

Note

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

Functions​

Aggregation functions​

  • AVERAGEA
  • AVERAGEX
  • COUNTA
  • COUNTAX
  • COUNTBLANK
  • COUNTROWS
  • COUNTX
  • DISTINCTCOUNTNOBLANK
  • MAXA
  • MAXX
  • MINA
  • MINX
  • PRODUCTX
  • SUMX

Date and time functions​

  • DATE
  • DATEDIFF
  • DATEVALUE
  • DAY
  • EDATE
  • HOUR
  • MINUTE
  • MONTH
  • NOW
  • QUARTER
  • SECOND
  • TODAY
  • UTCNOW
  • UTCTODAY
  • WEEKDAY
  • WEEKNUM
  • YEAR

Filter functions​

  • ALL
  • ALLSELECTED
  • CALCULATE
  • CALCULATETABLE
  • FILTER
  • KEEPFILTERS
  • SELECTEDVALUE

Information functions​

  • ISBLANK
  • ISFILTERED

Logical functions​

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

Math functions​

  • ABS
  • CEILING
  • DIVIDE
  • FLOOR
  • INT
  • LN
  • LOG
  • LOG10
  • ROUND
  • ROUNDUP

Table functions​

  • ADDCOLUMNS
  • SUMMARIZE
  • TOPN

Text functions​

  • CONCATENATE
  • LEFT
  • MID
  • RIGHT
  • SUBSTITUTE

Time intelligence functions​

  • DATESMTD
  • DATESQTD
  • DATESYTD
  • ENDOFYEAR
  • STARTOFMONTH
  • STARTOFQUARTER

Operators​

Comparison operators​

  • =
  • ==
  • >
  • <
  • >=
  • <=
  • <>

Logical operators​

  • &&
  • ||

Mathematical operators​

  • +
  • -
  • *
  • /
  • ^

Text operators​

  • &

Statements​

  • RETURN
  • VAR