XNPV

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

Syntax

XNPV(<table>, <values>, <dates>, <rate>)

Parameters

TermDefinition
tableA table for which the values and dates expressions should be calculated.
valuesAn expression that returns the cash flow value for each row of the table.
datesAn expression that returns the cash flow date for each row of the table.
rateThe discount rate to apply to the cash flow for each row of the table.

Return value

Net present value.

Remarks

The value is calculated as the following summation:

XNPV Formula

The series of cash flow values must contain at least one positive number and one negative number.

Example

The following calculates the present value of the CashFlows table:

Present value := XNPV( CashFlows, [Payment], [Date], 0.09 )  
DatePayment
1/1/2014-10000
3/1/20142750
10/30/20144250
2/15/20153250
4/1/20152750

Present value = 2086.65

***** Related Blog Posts *****
60 Page DAX Formula Reference Guide Download Now Available
Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

***** Related Video Tutorials *****
Ultimate Beginners Guide to DAX

What Is DAX? & Why Do You Need To Learn It – (1.2) Ultimate Beginner Guide to DAX
Formula Syntax, Comments & Variables – (1.6) Ultimate Beginners Guide to DAX
Examples Of Advanced DAX – (1.18) Ultimate Beginners Guide to DAX

***** Related Course Modules *****
Ultimate Beginners Guide to DAX
Mastering DAX Calculations
Solving Analytical Scenarios w/ Power BI and DAX
DAX Formula Deep Dives
Advanced DAX Combinations

***** Related Support Forum Posts*****
Mastering DAX Calculations: What Is DAX?
Understanding DAX Formula
Developing Complex Dax functions