# RRI

Returns an equivalent interest rate for the growth of an investment.

## Syntax

```
RRI(<nper>, <pv>, <fv>)
```

### Parameters

Term | Definition |
---|---|

nper | The number of periods for the investment. |

pv | The present value of the investment. |

fv | The future value of the investment. |

## Return Value

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:

$$\bigg( \frac{\text{fv}}{\text{pv}} \bigg)^{(\frac{1}{\text{}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.

## Example

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 |

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for