PV

PV is a DAX function that calculates the present value of a loan or investment based on a constant interest rate and periodic payments or a future value goal.

Syntax

PV(
   Rate,
   Nper,
   Pmt,
   Fv,
   Type
)

Argument	Properties	Description
Rate		The interest rate per period.
Nper		The total number of payment periods in an annuity.
Pmt		The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes.
Fv	Optional	The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be BLANK.
Type	Optional	The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.

Return Values

The present value of a loan or investment.

Remarks

• Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 0.12/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 0.12 for rate and 4 for nper.

• The following functions apply to annuities:

  • CUMIPMT
  • CUMPRINC
  • FV
  • IPMT
  • PMT
  • PPMT
  • PV
  • RATE
  • XIRR
  • XNPV

• An annuity is a series of constant cash payments made over a continuous period. For example, a car loan or a mortgage is an annuity. For more information, see the description for each annuity function.

• In annuity functions, cash you pay out, such as a deposit to savings, is represented by a negative number; cash you receive, such as a dividend check, is represented by a positive number. For example, a $1,000 deposit to the bank would be represented by the argument -1000 if you are the depositor and by the argument 1000 if you are the bank.

• One financial argument is solved in terms of the others.

  • If rate is not 0, then:

    $$\text{pv}\times (1+\text{rate}{)}^{\text{nper}}+\text{pmt}(1+\text{rate}\times \text{type})\times (\frac{(1+\text{rate}{)}^{\text{nper}}-1}{\text{rate}})+\text{fv}=0$$

  • If rate is 0, then:

    $$(\text{pmt}\times \text{nper})+\text{pv}+\text{fv}=0$$

• type is rounded to the nearest integer.

• An error is returned if:

  • nper < 1 or blank

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

Data	Description
$500.00	Money paid out of an insurance annuity at the end of every month.
8%	Interest rate earned on the money paid out.
20	Years the money will be paid out.

The following DAX query:

EVALUATE
{
  PV(0.08/12, 12*20, 500.00, 0, 0)
}

Returns the present value of an annuity using the terms specified above.

[Value]
-59777.1458511878

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