Documentation
Reference

DAX API reference

The DAX API supports the following functions.

If you'd like to propose a function to be supported in the DAX API, please contact the customer success team in Cube Cloud.

DAX functions

The DAX API currently implements a subset of functions supported by DAX (opens in a new tab).

Aggregation functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
AVERAGE (opens in a new tab)
AVERAGEA (opens in a new tab)
AVERAGEX (opens in a new tab)Non-base table as input table
COUNT (opens in a new tab)
COUNTA (opens in a new tab)
COUNTAX (opens in a new tab)Non-base table as input table
COUNTBLANK (opens in a new tab)
COUNTROWS (opens in a new tab)Disregards input table expression and always returns 50000
COUNTX (opens in a new tab)Non-base table as input table
DISTINCTCOUNT (opens in a new tab)Blanks are ignored
DISTINCTCOUNTNOBLANK (opens in a new tab)
MAX (opens in a new tab)Blanks are disregarded instead of being treated as 0 in two-argument variant
MAXA (opens in a new tab)
MAXX (opens in a new tab)Non-base table as input table
MIN (opens in a new tab)Blanks are disregarded instead of being treated as 0 in two-argument variant
MINA (opens in a new tab)
MINX (opens in a new tab)Non-base table as input table
SUM (opens in a new tab)
SUMX (opens in a new tab)Non-base table as input table

Date and time functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
DATE (opens in a new tab)Non-literal date parts
DAY (opens in a new tab)
HOUR (opens in a new tab)
MINUTE (opens in a new tab)
MONTH (opens in a new tab)
NOW (opens in a new tab)Time zone may depend on data warehouse settings
QUARTER (opens in a new tab)
SECOND (opens in a new tab)
TIME (opens in a new tab)Non-literal date parts
TODAY (opens in a new tab)Time zone may depend on data warehouse settings
UTCNOW (opens in a new tab)Time zone may depend on data warehouse settings
UTCTODAY (opens in a new tab)Time zone may depend on data warehouse settings
WEEKDAY (opens in a new tab)
YEAR (opens in a new tab)

Filter functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
ALL (opens in a new tab)2+ argumentsDoesn't clear filter context, silently ignored
CALCULATE (opens in a new tab)Creating a nested filter context
CALCULATETABLE (opens in a new tab)Creating a nested filter context
FILTER (opens in a new tab)
KEEPFILTERS (opens in a new tab)Doesn't modify behavior, silently ignored

Financial functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

No financial functions currently supported.

INFO functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

No INFO functions currently supported.

Information functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
ISAFTER (opens in a new tab)
ISBLANK (opens in a new tab)
ISEVEN (opens in a new tab)
ISODD (opens in a new tab)
ISONORAFTER (opens in a new tab)
NONVISUAL (opens in a new tab)Doesn't modify behavior, silently ignored
USERCULTURE (opens in a new tab)Always returns "en-US"

Logical functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
AND (opens in a new tab)
FALSE (opens in a new tab)
IF (opens in a new tab)Coerces results to common type
NOT (opens in a new tab)
OR (opens in a new tab)
SWITCH (opens in a new tab)
TRUE (opens in a new tab)

Math and trig functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
ABS (opens in a new tab)
ACOS (opens in a new tab)
ASIN (opens in a new tab)
ATAN (opens in a new tab)
CEILING (opens in a new tab)Significance other than 1
CONVERT (opens in a new tab)
COS (opens in a new tab)
DIVIDE (opens in a new tab)
EXP (opens in a new tab)
FLOOR (opens in a new tab)Significance other than 1
INT (opens in a new tab)
LN (opens in a new tab)
LOG (opens in a new tab)Base other than 10
LOG10 (opens in a new tab)
MOD (opens in a new tab)
MROUND (opens in a new tab)Multiple other than 1
PI (opens in a new tab)
POWER (opens in a new tab)
QUOTIENT (opens in a new tab)
RAND (opens in a new tab)
ROUND (opens in a new tab)Num digits other than 0
ROUNDDOWN (opens in a new tab)Num digits other than 0
ROUNDUP (opens in a new tab)Num digits other than 0
SIN (opens in a new tab)
SQRT (opens in a new tab)
SQRTPI (opens in a new tab)
TAN (opens in a new tab)
TRUNC (opens in a new tab)Num digits other than 0

Other functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
BLANK (opens in a new tab)

Parent and child functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

No parent and child functions currently supported.

Relationship functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

No relationship functions currently supported.

Statistical functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
SAMPLE (opens in a new tab)Doesn't evenly distribute rows, taking top N instead (acts as the TOPN function)

Table manipulation functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
ADDCOLUMNS (opens in a new tab)Aggregate expressions
CURRENTGROUP (opens in a new tab)
DISTINCT (opens in a new tab) (column)
DISTINCT (opens in a new tab) (table)Filter context for table expressions
GROUPBY (opens in a new tab)
IGNORE (opens in a new tab)2+ argumentsDoesn't modify filter context, silently ignored
NATURALINNERJOIN (opens in a new tab)
NATURALLEFTOUTERJOIN (opens in a new tab)
ROLLUPADDISSUBTOTAL (opens in a new tab)grandtotalFilter
ROLLUPGROUP (opens in a new tab)
ROW (opens in a new tab)
SELECTCOLUMNS (opens in a new tab)Optional aliases (currently mandatory)
SUBSTITUTEWITHINDEX (opens in a new tab)
SUMMARIZE (opens in a new tab)Named expressions (aggregations/measures)
SUMMARIZECOLUMNS (opens in a new tab)
TOPN (opens in a new tab)Non-literal N value
TREATAS (opens in a new tab)Non-literal tables as table expressions
VALUES (opens in a new tab)

Text functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

FunctionUnsupported featuresCaveats
CONCATENATE (opens in a new tab)
EXACT (opens in a new tab)
FIND (opens in a new tab)Start num other than 1 and not found value other than 0
LEFT (opens in a new tab)
LEN (opens in a new tab)
LOWER (opens in a new tab)
MID (opens in a new tab)
REPT (opens in a new tab)Returns empty string when num times is 0
RIGHT (opens in a new tab)
SUBSTITUTE (opens in a new tab)Instance number
SEARCH (opens in a new tab)Execution outside filter context functions
TRIM (opens in a new tab)Trimming inner whitespace
UPPER (opens in a new tab)
VALUE (opens in a new tab)

Time intelligence functions

Learn more in the relevant section (opens in a new tab) of the DAX documentation.

No time intelligence functions currently supported.

Miscellaneous functions

FunctionUnsupported featuresCaveats
GROUPCROSSAPPLY (opens in a new tab)
SAMPLEAXISWITHLOCALMINMAX (opens in a new tab)Silently ignored, returning input table expression