CUMIPMT DAX Function (Financial)
Returns the cumulative interest paid on a loan between start_period and end_period.
Syntax
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
Last update: Mar 1, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://support.microsoft.com/en-us/office/cumipmt-function-61067bb0-9016-427d-b95b-1a752af0e606