PDURATION

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the number of periods required by an investment to reach a specified value.

Syntax

PDURATION(<rate>, <pv>, <fv>)

Parameters

Return Value

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.

Example 1

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.

Example 2

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.