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
BITAND November, 2021 Returns a bitwise 'AND' of two numbers.
BITLSHIFT November, 2021 Returns a number shifted left by the specified number of bits.
BITOR November, 2021 Returns a bitwise 'OR' of two numbers.
BITRSHIFT November, 2021 Returns a number shifted right by the specified number of bits.
BITXOR November, 2021 Returns a bitwise 'XOR' of two numbers.
IF.EAGER March, 2021 Checks a condition, and returns one value when TRUE, otherwise it returns a second value.

Updated functions

Function Month Description
CALCULATE September, 2021 Support for aggregation functions in boolean filter expressions.
CALCULATETABLE September, 2021 Support for aggregation functions in boolean filter expressions.
FORMAT September, 2021 Additional locale_name parameter that specifies the name of a locale to be used by format_string.
XIRR September, 2021 Additional alternateResult parameter that specifies a result to be returned instead of an error if XIRR cannot determine a solution.
CROSSFILTER April, 2021 Additional options for the Direction parameter.
CALCULATE March, 2021 Support for OR (||) operator when there are multiple filters.