CUMIPMT DAX Function (Financial)
Returns the cumulative interest paid on a loan between start_period and end_period.
Syntax
CUMIPMT ( <Rate>, <Nper>, <Pv>, <Start_period>, <End_period>, <Type> )
| Parameter | Attributes | Description |
|---|---|---|
| Rate |
The interest rate. |
|
| Nper |
The total number of payment periods. |
|
| Pv |
The present value. |
|
| Start_period |
The first period in the calculation. Payment periods are numbered beginning with 1. |
|
| End_period |
The last period in the calculation. |
|
| Type |
The timing of the payment. |
Return values
Scalar A single decimal value.
Last update: Jul 8, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://support.microsoft.com/en-us/office/cumipmt-function-61067bb0-9016-427d-b95b-1a752af0e606