XNPV Function (DAX)
|
Returns the present value for a schedule of cash flows that is not necessarily periodic.
XNPV(<table>, <values>, <dates>, <rate>)
Parameters
| Term | Definition |
|---|---|
| table | A table for which the values and dates expressions should be calculated. |
| values | An expression that returns the cash flow value for each row of the table. |
| dates | An expression that returns the cash flow date for each row of the table. |
| 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:

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 )
| Date | Payment |
|---|---|
| 1/1/2014 | -10000 |
| 3/1/2014 | 2750 |
| 10/30/2014 | 4250 |
| 2/15/2015 | 3250 |
| 4/1/2015 | 2750 |
Present value = 2086.65
Community Additions
ADD
Show: