SQL Server 2016 Analysis Services (SSAS)*, Power Pivot in Excel 2016, and Power BI Desktop include the following new Data Analysis Expressions (DAX) functions:

### Date and Time Functions

CALENDAR Function

CALENDARAUTO Function

DATEDIFF Function

### Information Functions

ISEMPTY Function

ISONORAFTER Function

### Filter Functions

ADDMISSINGITEMS Function

SUBSTITUTEWITHINDEX Function

### Math and Trig Functions

ACOS Function

ACOSH Function

ASIN Function

ASINH Function

ATAN Function

ATANH Function

COMBIN Function

COMBINA Function

COS Function

COSH Function

DEGREES Function

EVEN Function

EXP Function

GCD Function

ISO.CEILING Function

LCM Function

MROUND Function

ODD Function

PI Function

PRODUCT Function

PRODUCTX Function

QUOTIENT Function

RADIANS Function

SIN Function

SINH Function

SQRTPI Function

TAN Function

TANH Function

### Statistical Functions

BETA.DIST Function

BETA.INV Function

CHISQ.INV Function

CHISQ.INV.RT Function

CONFIDENCE.NORM Function

CONFIDENCE.T Function

EXPON.DIST Function

GEOMEAN Function

GEOMEANX Function

MEDIAN Function

MEDIANX Function

PERCENTILE.EXC Function

PERCENTILE.INC Function

PERCENTILEX.EXC Function

PERCENTILEX.INC Function

SELECTCOLUMNS Function

XIRR Function

XNPV Function

### Text Functions

### Other Functions

GROUPBY Function

INTERSECT Function

NATURALINNERJOIN Function

NATURALLEFTOUTERJOIN Function

SUMMARIZECOLUMNS Function

UNION Function

VAR