DAX Statistical - XNPV function


Advertisements

Description

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

DAX XNPV function is new in Excel 2016.

Syntax

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

Parameters

Sr.No. Parameter & Description
1

table

A table for which the values and dates expressions should be calculated.

2

values

An expression that returns the cash flow value for each row of the table.

3

dates

An expression that returns the cash flow date for each row of the table.

4

rate

The 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 −

$$\sum_{j=1}^N\:\frac{P_{j}}{(1+rate)\frac{d_{j}-d_{1}}{365}}$$

Where $P_{j}$ is the j-th payment $d_{j}$ payment date, and $d_{1}$ is the first payment date.

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

Example

= XNPV (CashFlows, [AMOUNT], [DATE],8.5) 
dax_functions_statistical.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements