XNPV DAX Function (Financial)
Returns the net present value for a schedule of cash flows.
Syntax
XNPV ( <Table>, <Values>, <Dates>, <Rate> )
| Parameter | Attributes | Description |
|---|---|---|
|
Table Iterator |
The table containing the rows for which the Values and Dates expressions will be evaluated. |
|
|
Values Row Context |
An expression to be evaluated for each row of the table, which will yield a series of cash flows. |
|
|
Dates Row Context |
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. |
Return values
Scalar A single decimal value.
Net present value.
Related functions
Other related functions are:
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/xnpv-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies