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.
| Function | Caveats | |
|---|---|---|
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.
| Function | Caveats | |
|---|---|---|
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.
| Function | Caveats | |
|---|---|---|
ALL (opens in a new tab) | — | — |
CALCULATE (opens in a new tab) | — | Adds to the filter context but does not override it |
CALCULATETABLE (opens in a new tab) | — | — |
FILTER (opens in a new tab) | — | — |
KEEPFILTERS (opens in a new tab) | — | — |
Financial functions
Learn more in the relevant section (opens in a new tab) of the DAX documentation.
| Function | Caveats | |
|---|---|---|
XIRR (opens in a new tab) | — | — |
See the XIRR recipe for more details.
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.
| Function | Caveats | |
|---|---|---|
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) | — | — |
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.
| Function | Caveats | |
|---|---|---|
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.
| Function | Caveats | |
|---|---|---|
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.
| Function | Caveats | |
|---|---|---|
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.
| Function | Caveats | |
|---|---|---|
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.
| Function | Caveats | |
|---|---|---|
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) | — | — |
GROUPBY (opens in a new tab) | — | — |
IGNORE (opens in a new tab) | — | — |
NATURALINNERJOIN (opens in a new tab) | — | — |
NATURALLEFTOUTERJOIN (opens in a new tab) | — | — |
ROLLUPADDISSUBTOTAL (opens in a new tab) | — | — |
ROLLUPGROUP (opens in a new tab) | — | — |
ROW (opens in a new tab) | — | — |
SELECTCOLUMNS (opens in a new tab) | — | — |
SUBSTITUTEWITHINDEX (opens in a new tab) | — | — |
SUMMARIZE (opens in a new tab) | — | — |
SUMMARIZECOLUMNS (opens in a new tab) | — | — |
TOPN (opens in a new tab) | — | Complex N values are planned as 50000 |
TREATAS (opens in a new tab) | Non-literal tables as table expressions | — |
UNION (opens in a new tab) | — | — |
VALUES (opens in a new tab) | — | — |
Text functions
Learn more in the relevant section (opens in a new tab) of the DAX documentation.
| Function | Caveats | |
|---|---|---|
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
| Function | Caveats | |
|---|---|---|
GROUPCROSSAPPLY (opens in a new tab) | — | Ignores filter tables, acts as the SUMMARIZECOLUMNS function |
SAMPLEAXISWITHLOCALMINMAX (opens in a new tab) | — | Acts as the TOPN function |