XNPV DAX Function (Financial)
Returns the net present value for a schedule of cash flows.
Syntax
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
Net present value.
Related functions
Other related functions are:
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/xnpv-function-dax