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.
IN Operator / CONTAINSROW Function
The following functions now support string data types:
Show: