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) | — | — |
COUNT (opens in a new tab) | — | Counts all rows instead of only non-blank ones |
COUNTROWS (opens in a new tab) | — | Disregards input table expression and always returns 1 |
MAX (opens in a new tab) | 2 arguments | Blanks are disregarded instead of being treated as 0 |
MIN (opens in a new tab) | 2 arguments | Blanks are disregarded instead of being treated as 0 |
SUM (opens in a new tab) | — | — |
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 | — |
TIME (opens in a new tab) | Non-literal date parts. Execution outside DATE(...) + TIME(...) expression | — |
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) | 2+ arguments | Doesn'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.
Information functions
Learn more in the relevant section (opens in a new tab) of the DAX documentation.
| Function | Caveats | |
|---|---|---|
ISBLANK (opens in a new tab) | — | Blanks are treated as equivalent to nulls and vice versa |
ISONORAFTER (opens in a new tab) | — | — |
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) | — | — |
NOT (opens in a new tab) | — | — |
OR (opens in a new tab) | — | — |
Math and trig functions
Learn more in the relevant section (opens in a new tab) of the DAX documentation.
No math and trig functions currently supported.
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) | — | Blanks are treated as equivalent to nulls and vice versa |
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 | — |
DISTINCT (opens in a new tab) (column) | — | — |
DISTINCT (opens in a new tab) (table) | Filter context for table expressions | — |
IGNORE (opens in a new tab) | 2+ arguments | Doesn't modify filter context, silently ignored |
NATURALLEFTOUTERJOIN (opens in a new tab) | — | — |
ROLLUPADDISSUBTOTAL (opens in a new tab) | grandtotalFilter, groupLevelFilter | — |
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.
| Function | Caveats | |
|---|---|---|
SEARCH (opens in a new tab) | Execution outside filter context functions | — |
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 | |
|---|---|---|
SAMPLEAXISWITHLOCALMINMAX (opens in a new tab) | — | Silently ignored, returning input table expression |