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