description | title | author |
---|---|---|
Learn more about: CUMPRINC |
CUMPRINC function (DAX) | Microsoft Docs |
jajin7 |
[!INCLUDEapplies-to-measures-columns-tables-visual-calculations]
Returns the cumulative principal paid on a loan between start_period and end_period.
CUMPRINC(<rate>, <nper>, <pv>, <start_period>, <end_period>, <type>)
Term | Definition |
---|---|
rate | The interest rate. |
nper | The total number of payment periods. |
pv | The present value. |
start_period | The first period in the calculation. Must be between 1 and end_period (inclusive). |
end_period | The last period in the calculation. Must be between start_period and nper (inclusive). |
type | The timing of the payment. The accepted values are listed below this table. |
The type parameter accepts the following values:
Type | Timing |
---|---|
0 (zero) | Payment at the end of the period |
1 | Payment at the beginning of the period |
The cumulative principal paid in the specified period.
-
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 an annual interest rate of 10 percent, use 0.1/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 0.1 for rate and 4 for nper.
-
start_period, end_period, and type are rounded to the nearest integer.
-
An error is returned if:
- rate ≤ 0.
- nper < 1.
- pv ≤ 0.
- start_period < 1 or start_period > end_period.
- end_period < start_period or end_period > nper.
- type is any number other than 0 or 1.
-
[!INCLUDE function-not-supported-in-directquery-mode]
Data | Description |
---|---|
9% | Annual interest rate |
30 | Term in years |
125000 | Present value |
The following DAX query:
EVALUATE
{
CUMPRINC(0.09/12, 30*12, 125000, 13, 24, 1)
}
Returns the total principal paid in the second year of payments, periods 13 through 24, assuming the payments are made at the beginning of each month.
[Value] |
---|
-927.153472378062 |
The following DAX query:
EVALUATE
{
CUMPRINC(0.09/12, 30*12, 125000, 1, 1, 0)
}
Returns the principal paid in a single payment in the first month, assuming the payment is made at the end of the month.
[Value] |
---|
-68.2782711809784 |