FV

FV is a DAX function that calculates the future value of an investment based on a constant interest rate and periodic payments.

Syntax

FV(
   Rate,
   Nper,
   Pmt,
   Pv,
   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.
Pv	Optional	The present value, or the lump-sum amount that a series of future payments is worth right now. If pv 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 future value of an 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.

• For all the arguments, cash you pay out, such as deposits to savings, is represented by negative numbers; cash you receive, such as dividend checks, is represented by positive numbers.

• type is rounded to the nearest integer.

• An error is returned if:

  • nper < 1

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

Data	Description
6%	Annual interest rate
10	Number of payments
-200	Amount of the payment
-500	Present value
1	Payment is due at the beginning of the period (0 indicates payment is due at end of period)

The following DAX query:

EVALUATE
{
  FV(0.06/12, 10, -200, -500, 1)
}

Returns the future value of an investment using the terms specified above.

[Value]
2581.40337406012

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