DDB

How to Use the Power BI DAX function DDB

Syntax of the DDB Function

The syntax of the DDB function is as follows:


DDB(cost, salvage, life, period, factor)


where:

- `cost`: The initial cost of the asset

- `salvage`: The value of the asset at the end of its useful life

- `life`: The number of periods over which the asset is depreciated

- `period`: The period for which you want to calculate the depreciation

- `factor`: The rate at which the asset is depreciated. The default value is 2.

How to Use the DDB Function

Using the DDB function in Power BI is quite simple. First, you need to insert a new column in your dataset where you want to calculate the depreciation. Then, you need to use the DDB function in the formula.

Let's say you have a dataset that contains the cost, salvage value, and life of an asset. You want to calculate the depreciation for each year of the asset's life. Here's how you can do it:

1. Insert a new column in your dataset and name it "Depreciation".

2. In the formula bar, type the following formula:


=DDB(cost, salvage, life, period, factor)


3. Replace the arguments in the formula with the appropriate cell references.

For example, if the cost of the asset is in cell A2, the salvage value is in cell B2, the life in years is in cell C2, the period for which you want to calculate the depreciation is in cell D2, and the factor is 2, the formula should look like this:


=DDB(A2, B2, C2, D2, 2)


4. Press Enter to calculate the depreciation for the first period.

5. Copy the formula down to calculate the depreciation for all the periods.

Example

Let's take an example to understand the DDB function better. Suppose you have purchased a machine for $10,000. The estimated salvage value of the machine at the end of its useful life is $2,000. The useful life of the machine is 5 years. You want to calculate the depreciation for each year using the DDB function.

Here's how you can do it:

1. Insert a new column in your dataset and name it "Depreciation".

2. In the formula bar, type the following formula:


=DDB(10000, 2000, 5, 1, 2)


3. Press Enter to calculate the depreciation for the first year.

4. Copy the formula down to calculate the depreciation for all the years.

The result should look like this:

| Cost | Salvage | Life | Period | Factor | Depreciation |

|------|---------|------|--------|--------|--------------|

| 10000 | 2000 | 5 | 1 | 2 | 4000 |

| 10000 | 2000 | 5 | 2 | 2 | 2400 |

| 10000 | 2000 | 5 | 3 | 2 | 1440 |

| 10000 | 2000 | 5 | 4 | 2 | 864 |

| 10000 | 2000 | 5 | 5 | 2 | 1032 |

The DDB function is a powerful financial function in Power BI that allows you to calculate the depreciation of an asset over a given period. By following the steps outlined in this article, you can easily use the DDB function in your Power BI reports and analyses.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)