New DAX Functions

 

DAX is continuously being improved with new functions and functionality to support new features in Power BI, Analysis Services, and Excel. Not all new improvements are supported in earlier versions of SQL Server Analysis Services, Power BI Desktop, and Power Pivot in Excel.

The following functions (or functionality) have been added in 2017.

ERROR Function

GENERATESERIES Function

IN Operator / CONTAINSROW Function

SELECTEDVALUE Function

TREATAS Function

Table Constructor

UNICHAR Function

The following functions now support string data types:

MIN Function

MAX Function

MINX Function

MAXX Function

Show: