RRI

RRI is a DAX function that returns the equivalent interest rate for the growth of an investment.

Syntax

RRI(
   Nper,
   Pv,
   Fv
)

Argument	Properties	Description
Nper		The number of periods for the investment.
Pv		The present value of the investment.
Fv		The future value of the investment.

Return Values

The equivalent interest rate.

Remarks

• RRI returns the interest rate given $\text{nper}$ (the number of periods), $\text{pv}$ (present value), and $\text{fv}$ (future value), calculated by using the following equation:

  $$(\frac{\text{fv}}{\text{pv}}{)}^{(\frac{1}{nper})}-1$$

• An error is returned if:

  • nper ≤ 0.

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

Data	Description
$10,000	Present value
$21,000	Future value
4	Years invested

The following DAX query:

EVALUATE
{
  RRI(4*12, 10000, 21000)
}

Returns an equivalent interest rate for the growth of an investment with the terms specified above.

[Value]
0.0155771057566627

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