DAX Statistical - XNPV function

Description

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

DAX XNPV function is new in Excel 2016.

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

Sr.No.	Parameter & Description
1	table A table for which the values and dates expressions should be calculated.
2	values An expression that returns the cash flow value for each row of the table.
3	dates An expression that returns the cash flow date for each row of the table.
4	rate The 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 −

$$\sum_{j=1}^N\:\frac{P_{j}}{(1+rate)\frac{d_{j}-d_{1}}{365}}$$

Where $P_{j}$ is the j-th payment $d_{j}$ payment date, and $d_{1}$ is the first payment date.

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

= XNPV (CashFlows, [AMOUNT], [DATE],8.5)

dax_functions_statistical.htm