What are Cumulative financial functions in power bi DAX

This recipe explains what are Cumulative financial functions in power bi DAX

Recipe Objective - What are Cumulative financial functions in Power BI DAX?

Cumulative financial functions are used to calculate cumulative interest paid and cumulative principal paid on loan between the start and end periods.

CUMIPMT - Returns the cumulative interest paid on loan between Start_period and End_period.

CUMPRINC - Returns the cumulative principal paid on loan between Start_period and End_period.

Syntax of CUMIPMT -

CUMIPMT(Rate, Nper, Pv, Start_period, End_period, Type)

Parameters -

Settlement - The security's settlement date.

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.

Returns the interest paid in a single payment in the first month, assuming that the payment is made at the end of the month.

Syntax of CUMPRINC -

CUMPRINC(Rate, Nper, Pv, Start_period, End_period, Type)

Parameters -

Settlement - The security's settlement date.

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.

Returns the principal paid in a single payment in the first month, assuming the payment is made at the end of the month.

In this way, we can use Cumulative financial functions in Power BI DAX.

What Users are saying..

profile image

Anand Kumpatla

Sr Data Scientist @ Doubleslash Software Solutions Pvt Ltd
linkedin profile url

ProjectPro is a unique platform and helps many people in the industry to solve real-life problems with a step-by-step walkthrough of projects. A platform with some fantastic resources to gain... Read More

Relevant Projects

Build a Logistic Regression Model in Python from Scratch
Regression project to implement logistic regression in python from scratch on streaming app data.

Build a Multi ClassText Classification Model using Naive Bayes
Implement the Naive Bayes Algorithm to build a multi class text classification model in Python.

MLOps Project to Build Search Relevancy Algorithm with SBERT
In this MLOps SBERT project you will learn to build and deploy an accurate and scalable search algorithm on AWS using SBERT and ANNOY to enhance search relevancy in news articles.

Build an End-to-End AWS SageMaker Classification Model
MLOps on AWS SageMaker -Learn to Build an End-to-End Classification Model on SageMaker to predict a patient’s cause of death.

Build a Autoregressive and Moving Average Time Series Model
In this time series project, you will learn to build Autoregressive and Moving Average Time Series Models to forecast future readings, optimize performance, and harness the power of predictive analytics for sensor data.

Walmart Sales Forecasting Data Science Project
Data Science Project in R-Predict the sales for each department using historical markdown data from the Walmart dataset containing data of 45 Walmart stores.

Personalized Medicine: Redefining Cancer Treatment
In this Personalized Medicine Machine Learning Project you will learn to classify genetic mutations on the basis of medical literature into 9 classes.

Skip Gram Model Python Implementation for Word Embeddings
Skip-Gram Model word2vec Example -Learn how to implement the skip gram algorithm in NLP for word embeddings on a set of documents.

ML Model Deployment on AWS for Customer Churn Prediction
MLOps Project-Deploy Machine Learning Model to Production Python on AWS for Customer Churn Prediction

OpenCV Project to Master Advanced Computer Vision Concepts
In this OpenCV project, you will learn to implement advanced computer vision concepts and algorithms in OpenCV library using Python.