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.

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. New functions and updates to existing functions within the past year are shown here.

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, and then later in Analysis Services, Power Pivot in Excel, and tools.

New functions

Function Month Description
MATCHBY May, 2023 Define the columns that are used to to match data and identify the current row, in a window function expression.
RANK April, 2023 Returns the ranking for the current context within the specified partition, sorted by the specified order.
ROWNUMBER April, 2023 Returns the unique ranking for the current context within the specified partition, sorted by the specified order.
LINEST February, 2023 Uses the Least Squares method to calculate a straight line that best fits the given data.
LINESTX February, 2023 Uses the Least Squares method to calculate a straight line that best fits the given data. The data result from expressions evaluated for each row in a table.
INDEX December, 2022 Returns a row at an absolute position, specified by the position parameter, within the specified partition, sorted by the specified order or on the specified axis.
OFFSET December, 2022 Returns a single row that is positioned either before or after the current row within the same table, by a given offset.
ORDERBY December, 2022 Defines the columns that determine the sort order within each of a window function’s partitions.
PARTITIONBY December, 2022 Defines the columns that are used to partition a window function’s <relation> parameter.
WINDOW December, 2022 Returns multiple rows which are positioned within the given interval.
EVALUATEANDLOG November, 2022 Returns the value of the first argument and logs it in a DAX Evaluation Log profiler event.
TOCSV November, 2022 Returns a table as a string in CSV format. This function applies to Power BI Desktop only.
TOJSON November, 2022 Returns a table as a string in JSON format. This function applies to Power BI Desktop only.
NETWORKDAYS July, 2022 Returns the number of whole workdays between two dates.