XNPV Function (DAX)

 
System_CAPS_ICON_note.jpg Note


This function is included in SQL Server 2016 Analysis Services (SSAS), Power Pivot in Excel 2016, and Power BI Desktop only. Information provided here is subject to change.

Returns the present value for a schedule of cash flows that is not necessarily periodic.

XNPV(<table>, <values>, <dates>, <rate>)  

Parameters

TermDefinition
tableA table for which the values and dates expressions should be calculated.
valuesAn expression that returns the cash flow value for each row of the table.
datesAn expression that returns the cash flow date for each row of the table.
rateThe discount rate to apply to the cash flow for each row of the table.

Net present value.

The value is calculated as the following summation:

XNPV Formula

The series of cash flow values must contain at least one positive number and one negative number.

The following calculates the present value of the CashFlows table:

Present value := XNPV( CashFlows, [Payment], [Date], 0.09 )  

DatePayment
1/1/2014-10000
3/1/20142750
10/30/20144250
2/15/20153250
4/1/20152750

Present value = 2086.65

Community Additions

ADD
Show: