PDURATION

PDURATION is a DAX function that returns the number of periods required for an investment to reach a specified value.

Syntax

PDURATION(
   Rate,
   Pv,
   Fv
)

Argument	Properties	Description
Rate		The interest rate per period.
Pv		The present value of the investment.
Fv		The desired future value of the investment.

Return Values

The number of periods.

Remarks

• PDURATION uses the following equation:

  $$\text{PDURATION}=\frac{log(\text{fv})-log(\text{pv})}{log(1+\text{rate})}$$

• An error is returned if:

  • rate ≤ 0.
  • pv ≤ 0.
  • fv ≤ 0.

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

The following DAX query:

EVALUATE
{
  PDURATION(0.025, 2000, 2200)
}

Returns the number of years required for an investment of $2000, earning 2.5% annually, to reach $2200.

[Value]
3.85986616262266

The following DAX query:

EVALUATE
{
  PDURATION(0.025/12, 1000, 1200)
}

Returns the number of months required for an investment of $1000, earning 2.5% annually, to reach $1200.

[Value]
87.6054764193714

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