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 function 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.

New functions

Function Month
ACCRINT July. 2020
ACCRINTM July. 2020
AMORDEGRC July. 2020
AMORLINC July. 2020
COUPDAYBS July. 2020
COUPDAYS July. 2020
COUPDAYSNC July. 2020
COUPNCD July. 2020
COUPNUM July. 2020
COUPPCD July. 2020
CUMIPMT July. 2020
CUMPRINC July. 2020
DB July. 2020
DDB July. 2020
DISC July. 2020
DOLLARDE July. 2020
DOLLARFR July. 2020
DURATION July. 2020
EFFECT July. 2020
FV July. 2020
INTRATE July. 2020
IPMT July. 2020
ISPMT July. 2020
MDURATION July. 2020
NOMINAL July. 2020
NPER July. 2020
ODDFPRICE July. 2020
ODDFYIELD July. 2020
ODDLPRICE July. 2020
ODDLYIELD July. 2020
PDURATION July. 2020
PMT July. 2020
PPMT July. 2020
PRICE July. 2020
PRICEDISC July. 2020
PRICEMAT July. 2020
PV July. 2020
RATE July. 2020
RECEIVED July. 2020
RRI July. 2020
SLN July. 2020
SYD July. 2020
TBILLEQ July. 2020
TBILLPRICE July. 2020
TBILLYIELD July. 2020
VDB July. 2020
YIELD July. 2020
YIELDDISC July. 2020
YIELDMAT July. 2020
COALESCE March. 2020
FIRSTNONBLANKVALUE Feb. 2020
LASTNONBLANKVALUE Feb. 2020
CONVERT Sept. 2019
REMOVEFILTERS Sept. 2019

Updated functions

Function Month