नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
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 |