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 Formulas Reference Guide
Download DAX Formula Reference Guide