What are DB and DDB functions in power bi DAX

This recipe explains what are DB and DDB functions in power bi DAX

Recipe Objective - What are DB and DDB functions in Power BI DAX?

DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

DDB - Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.

Syntax of DB -

DB(Cost, Salvage, Life, Period, [Month])

Parameters -

Cost - The initial cost of the asset.

Salvage - The value at the end of the depreciation (sometimes called the asset's salvage value). This value can be 0.

Life - The number of periods over which the asset is being depreciated (sometimes called the asset's useful life).

Period - The period for which you want to calculate the depreciation. Period must use the same units as life. Must be between 1 and life (inclusive).

Month - (Optional) The number of months in the first year. If the month is omitted, it is assumed to be 12.

Returns the depreciation over the specified period.

Syntax of DDB -

DDB(Cost, Salvage, Life, Period, [Factor])

Parameters -

Cost - The initial cost of the asset.

Salvage - The value at the end of the depreciation (sometimes called the asset's salvage value). This value can be 0.

Life - The number of periods over which the asset is being depreciated (sometimes called the asset's useful life).

Period - The period for which you want to calculate the depreciation. Period must use the same units as life. Must be between 1 and life (inclusive).

Factor - (Optional) The rate at which the balance declines. If the factor is omitted, it is assumed to be 2 (the double-declining balance method).

Returns the depreciation over the specified period.

In this way, we can use DB and DDB functions in Power BI DAX.

What Users are saying..

profile image

Ed Godalle

Director Data Analytics at EY / EY Tech
linkedin profile url

I am the Director of Data Analytics with over 10+ years of IT experience. I have a background in SQL, Python, and Big Data working with Accenture, IBM, and Infosys. I am looking to enhance my skills... Read More

Relevant Projects

Customer Churn Prediction Analysis using Ensemble Techniques
In this machine learning churn project, we implement a churn prediction model in python using ensemble techniques.

Build Multi Class Text Classification Models with RNN and LSTM
In this Deep Learning Project, you will use the customer complaints data about consumer financial products to build multi-class text classification models using RNN and LSTM.

Time Series Analysis with Facebook Prophet Python and Cesium
Time Series Analysis Project - Use the Facebook Prophet and Cesium Open Source Library for Time Series Forecasting in Python

Langchain Project for Customer Support App in Python
In this LLM Project, you will learn how to enhance customer support interactions through Large Language Models (LLMs), enabling intelligent, context-aware responses. This Langchain project aims to seamlessly integrate LLM technology with databases, PDF knowledge bases, and audio processing agents to create a comprehensive customer support application.

PyCaret Project to Build and Deploy an ML App using Streamlit
In this PyCaret Project, you will build a customer segmentation model with PyCaret and deploy the machine learning application using Streamlit.

Tensorflow Transfer Learning Model for Image Classification
Image Classification Project - Build an Image Classification Model on a Dataset of T-Shirt Images for Binary Classification

Build a Churn Prediction Model using Ensemble Learning
Learn how to build ensemble machine learning models like Random Forest, Adaboost, and Gradient Boosting for Customer Churn Prediction using Python

PyTorch Project to Build a GAN Model on MNIST Dataset
In this deep learning project, you will learn how to build a GAN Model on MNIST Dataset for generating new images of handwritten digits.

NLP Project for Beginners on Text Processing and Classification
This Project Explains the Basic Text Preprocessing and How to Build a Classification Model in Python

Learn How to Build PyTorch Neural Networks from Scratch
In this deep learning project, you will learn how to build PyTorch neural networks from scratch.