XNPV - Daxplained

XNPV is a DAX function that returns the net present value for a schedule of cash flows.

Syntax

XNPV(
   Table,
   Values,
   Dates,
   Rate
)

Argument	Properties	Description
Table		The table containing the rows for which the Values and Dates expressions will be evaluated.
Values		An expression to be evaluated for each row of the table, which will yield a series of cash flows.
Dates		An expression to be evaluated for each row of the table, which will yield a schedule of payment dates.
Rate		The discount rate to apply to the cash flows.

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^{t h}$ payment
- $d_{j}$ is the $j^{t h}$ payment date
- $d_{1}$ is the first payment date
The series of cash flow values must contain at least one positive number and one negative number.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following calculates the present value of the CashFlows table:

= XNPV( CashFlows, [Payment], [Date], 0.09 )

Present value = 2089.50

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/xnpv-function-dax