New DAX functions

DAX is continuously being improved with new functions and functionality to support new features. New functions and updates are included in service, application, and tool updates which in most cases are monthly. SQL Server Analysis Services and Excel are updated in the next cumulative update. To get the latest, make sure you're using the latest version.

Important

Not all functions are supported in all versions of Power BI Desktop, Analysis Services, and Power Pivot in Excel.

New functions

Function Month
APPROXIMATEDISTINCTCOUNT (Preview) Dec. 2018
ISINSCOPE Nov. 2018
NORM.DIST August 2018
NORM.INV August 2018
NORM.S.DIST August 2018
NORM.S.INV August 2018
T.DIST August 2018
T.DIST.2T August 2018
T.DIST.RT August 2018
T.INV August 2018
T.INV.2T August 2018
DISTINCT (table) April 2018
COMBINEVALUES March 2018
UTCNOW March 2018
UTCTODAY March 2018

Updated functions

Function Month
SUMMARIZECOLUMNS function Nov. 2018