AMORDEGRC

How to Use the Power BI DAX function AMORDEGRC

What is the AMORDEGRC Function?

The AMORDEGRC function is a DAX function that is used to calculate the depreciation of an asset using a French accounting method. This method is commonly used in France and other French-speaking countries.

The function takes several arguments, including:

– Cost: The cost of the asset.

– Date of Purchase: The date the asset was purchased.

– First Period: The first period for which to calculate depreciation.

– Salvage: The salvage value of the asset.

– Rate: The rate of depreciation.

– Period: The period for which to calculate depreciation.

Using the AMORDEGRC Function in Power BI

To use the AMORDEGRC function in Power BI, you will need to follow these steps:

1. Open Power BI and create a new report.

2. In the formula bar, type =AMORDEGRC( to start the function.

3. Enter the required arguments in the function.

For example, if you want to calculate the depreciation of an asset that costs $10,000, was purchased on January 1, 2020, has a salvage value of $2,000, a depreciation rate of 10%, and you want to calculate depreciation for the second period, your formula would look like this:

=AMORDEGRC(10000,”01/01/2020″,1,2000,0.1,2)

4. Press Enter to calculate the depreciation of the asset.

Understanding the Arguments

Let’s take a closer look at each of the arguments in the AMORDEGRC function:

Cost

The cost argument is the cost of the asset. This includes any expenses related to acquiring the asset, such as delivery fees or installation costs.

Date of Purchase

The date of purchase argument is the date the asset was purchased. This is used to calculate the number of periods that have elapsed since the purchase date.

First Period

The first period argument is the first period for which to calculate depreciation. This is typically set to 1, as the first period is usually the period in which the asset was purchased.

Salvage

The salvage argument is the salvage value of the asset. This is the value of the asset at the end of its useful life. This is subtracted from the cost of the asset to determine the total depreciation.

Rate

The rate argument is the rate of depreciation. This is usually expressed as a percentage.

Period

The period argument is the period for which to calculate depreciation. This is typically set to the current period or the period for which you want to calculate depreciation.

The AMORDEGRC function is a powerful tool for calculating depreciation using a French accounting method in Power BI. By following the steps outlined in this article, you can use this function to calculate the depreciation of an asset in minutes. So, go ahead and give it a try!

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

Upcoming Courses

15-17 July 2024
16-18 September 2024
11-13 November 2024

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)