XNPV Function (DAX)

How does the XNPV function (DAX) work?

The XNPV function (DAX) returns the present value for a schedule of cash flows that is not necessarily periodic.

XNPV Formula Syntax

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

How do you use the XNPV function?

The Excel XNPV function calculates the net present value (NPV) of an investment based on a discount rate and a series of cash flows that occur at irregular intervals. Cash flows need to be listed with dates in chronological order. Negative values represent cash paid out; positive values represent cash received

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the XNPV function

  • Rate is provided as a percentage (.12 for 12%)
  • Dates and values must be in chronological order.
  • Dates must be valid Excel dates
  • XNPV doesn’t discount the initial cash flow

Related Video Tutorials

Formula examples using the XNPV function

Present value := XNPV( CashFlows, [Payment], [Date], 0.09 )

=XNPV(F4,B5:B10,C5:C10)

=XNPV(.09, A2:A6, B2:B6)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.