## How does the XNPVfunction (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 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

## 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 