NPER

Updated on

NPER is a DAX function that returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

Syntax

NPER(
   Rate,
   Pmt,
   Pv,
   Fv,
   Type
)
Argument Properties Description
Rate The interest rate per period.
Pmt The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes.
Pv The present value, or the lump-sum amount that a series of future payments is worth right now.
Fv Optional The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be BLANK.
Type Optional The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.

Return Values

The number of periods for an investment.

Remarks

  • type is rounded to the nearest integer.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

Data Description
12% Annual interest rate
-100 Payment made each period
-1000 Present value
10000 Future value
1 Payment is due at the beginning of the period (see above)

The following DAX query:

EVALUATE
{
  NPER(0.12/12, -100, -1000, 10000, 1)
}

Returns the number of periods for the investment described by the terms specified above.

[Value]
59.6738656742946

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/nper-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy