# 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

Video

#### Mastering DAX Studio

Featured

24 Lectures 2 hours

Video

#### DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Advertisements