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

     <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(.09, A2:A6, B2:B6)

Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formula Reference Guide