Table of contents
TOC
Collapse the table of content
Expand the table of content

Data Analysis Expressions (DAX) Reference

Mike Kinsman|Last Updated: 10/5/2018

New DAX Functions

DAX Function Reference

Date and Time Functions

CALENDAR Function

CALENDARAUTO Function

DATE Function

DATEDIFF Function

DATEVALUE Function

DAY Function

EDATE Function

EOMONTH Function

HOUR Function

MINUTE Function

MONTH Function

NOW Function

SECOND Function

TIME Function

TIMEVALUE Function

TODAY Function

WEEKDAY Function

WEEKNUM Function

YEAR Function

YEARFRAC Function

Time Intelligence Functions

CLOSINGBALANCEMONTH Function

CLOSINGBALANCEQUARTER Function

CLOSINGBALANCEYEAR Function

DATEADD Function

DATESBETWEEN Function

DATESINPERIOD Function

DATESMTD Function

DATESQTD Function

DATESYTD Function

ENDOFMONTH Function

ENDOFQUARTER Function

ENDOFYEAR Function

FIRSTDATE Function

FIRSTNONBLANK Function

LASTDATE Function

LASTNONBLANK Function

NEXTDAY Function

NEXTMONTH Function

NEXTQUARTER Function

NEXTYEAR Function

OPENINGBALANCEMONTH Function

OPENINGBALANCEQUARTER Function

OPENINGBALANCEYEAR Function

PARALLELPERIOD Function

PREVIOUSDAY Function

PREVIOUSMONTH Function

PREVIOUSQUARTER Function

PREVIOUSYEAR Function

SAMEPERIODLASTYEAR Function

STARTOFMONTH Function

STARTOFQUARTER Function

STARTOFYEAR Function

TOTALMTD Function

TOTALQTD Function

TOTALYTD Function

Filter Functions

ADDMISSINGITEMS Function

ALL Function

ALLEXCEPT Function

ALLNOBLANKROW Function

ALLSELECTED Function

CALCULATE Function

CALCULATETABLE Function

CROSSFILTER Function

DISTINCT Function

EARLIER Function

EARLIEST Function

FILTER Function

FILTERS Function

HASONEFILTER Function

HASONEVALUE Function

ISCROSSFILTERED Function

ISFILTERED Function

KEEPFILTERS Function

RELATEDTABLE Function

SELECTEDVALUE Function

SUBSTITUTEWITHINDEX Function

USERELATIONSHIP Function

VALUES Function

Information Functions

CONTAINS Function

CUSTOMDATA Function

IN Operator / CONTAINSROW Function

ISBLANK Function

ISERROR Function

ISEVEN Function

ISLOGICAL Function

ISNONTEXT Function

ISNUMBER Function

ISODD Function

ISONORAFTER Function

ISTEXT Function

LOOKUPVALUE Function

USERNAME Function

Logical Functions

AND Function

FALSE Function

IF Function

IFERROR Function

IN Function

NOT Function

OR Function

SWITCH Function

TRUE Function

Math and Trig Functions

ABS Function

ACOS Function

ACOSH Function

ASIN Function

ASINH Function

ATAN Function

ATANH Function

CEILING Function

COMBIN Function

COMBINA Function

COS Function

COSH Function

CURRENCY Function

DEGREES Function

DIVIDE Function

EVEN Function

EXP Function

FACT Function

FLOOR Function

GCD Function

INT Function

ISO.CEILING Function

LCM Function

LN Function

LOG Function

LOG10 Function

MOD Function

MROUND Function

ODD Function

PI Function

POWER Function

PRODUCT Function

PRODUCTX Function

QUOTIENT Function

RADIANS Function

RAND Function

RANDBETWEEN Function

ROUND Function

ROUNDDOWN Function

ROUNDUP Function

SIGN Function

SQRT Function

SUM Function

SUMX Function

TRUNC Function

Other Functions

DATATABLE Function

ERROR Function

EXCEPT Function

GENERATESERIES Function

GROUPBY Function

INTERSECT Function

ISEMPTY Function

NATURALINNERJOIN Function

NATURALLEFTOUTERJOIN Function

SUMMARIZECOLUMNS Function

Table Constructor

TREATAS Function

UNION Function

VAR

Parent and Child Functions

Understanding Functions for Parent-Child Hierarchies

PATH Function

PATHCONTAINS Function

PATHITEM Function

PATHITEMREVERSE Function

PATHLENGTH Function

Statistical Functions

ADDCOLUMNS Function

AVERAGE Function

AVERAGEA Function

AVERAGEX Function

BETA.DIST Function

BETA.INV Function

CHISQ.INV Function

CHISQ.INV.RT Function

CONFIDENCE.NORM Function

CONFIDENCE.T Function

COUNT Function

COUNTA Function

COUNTAX Function

COUNTBLANK Function

COUNTROWS Function

COUNTX Function

CROSSJOIN Function

DISTINCTCOUNT Function

EXPON.DIST Function

GENERATE Function

GENERATEALL Function

GEOMEAN Function

GEOMEANX Function

MAX Function

MAXA Function

MAXX Function

MEDIAN Function

MEDIANX Function

MIN Function

MINA Function

MINX Function

PERCENTILE.EXC Function

PERCENTILE.INC Function

PERCENTILEX.EXC Function

PERCENTILEX.INC Function

PERMUT Function

POISSON.DIST Function

RANK.EQ Function

RANKX Function

ROW Function

SAMPLE Function

SELECTCOLUMNS Function (DAX)

SIN Function

SINH Function

STDEV.S Function

STDEV.P Function

STDEVX.S Function

STDEVX.P Function

SQRTPI Function

SUMMARIZE Function

TAN Function

TANH Function

TOPN Function

VAR.S Function

VAR.P Function

VARX.S Function

VARX.P Function

XIRR Function

XNPV Function

Text Functions

BLANK Function

CODE Function

CONCATENATE Function

CONCATENATEX Function

EXACT Function

FIND Function

FIXED Function

FORMAT Function

Pre-Defined Numeric Formats for the FORMAT Function
Custom Numeric Formats for the FORMAT Function
Pre-defined Date and Time formats for the FORMAT Function
Custom Date and Time formats for the FORMAT Function

LEFT Function

LEN Function

LOWER Function

MID Function

REPLACE Function

REPT Function

RIGHT Function

SEARCH Function

SUBSTITUTE Function

TRIM Function

UNICHAR Function (DAX)

UPPER Function

VALUE Function

DAX Syntax Reference

DAX Operator Reference

DAX Parameter-Naming Conventions

DAX Queries

DAX Error Reference

DAX Error: The calculation could not be completed. The formula for this calculation contains a time-intelligence function. Verify the column specified for the ‘date’ argument to the time-intelligence function contains a contiguous set of dates.

DAX Error: CALCULATION ABORTED: MdxScript(instance) (00, 0) Function ‘DATEADD’ only works with contiguous date selections.

DAX Semantic error: One or more expressions defined as filter arguments cannot be used in this expression. Rewrite your filter expression using the FILTER function.

DAX Semantic error: A function ‘CALCULATE’ has been used in a true-false expression that is used as a table filter expression. This is not allowed.

© 2018 Microsoft