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.

While functions and functionality are being updated all the time, only those updates that have a visible and functional change exposed to users are described in documentation.

Important

Not all functions are supported in all versions of Power BI Desktop, Analysis Services, and Power Pivot in Excel. New and updated functions are typically first introduced in Power BI Desktop.

New functions

Function Month
CONVERT Sept. 2019
REMOVEFILTERS Sept. 2019
SELECTEDMEASUREFORMATSTRING May 2019
ALLCROSSFILTERED April 2019
CONTAINSSTRING March 2019
CONTAINSSTRINGEXACT March 2019
DISTINCTCOUNTNOBLANK March 2019
ISSELECTEDSMEASURE March 2019
SELECTEDSMEASURE March 2019
SELECTEDSMEASURENAME March 2019
APPROXIMATEDISTINCTCOUNT (Preview) Dec. 2018
ISINSCOPE Nov. 2018

Updated functions

Function Month
ALL March 2019
LOOKUPVALUE March 2019
SUMMARIZECOLUMNS function Nov. 2018