XNPV

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


Syntax

XNPV(table, values, dates, rate)

Parameters

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.

Return Value

Net present value.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Statistical Functions / XNPV