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:
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:
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.
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.
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.
The rate argument is the rate of depreciation. This is usually expressed as a percentage.
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)
Power BI DAX Intensive Training Course£1,050.00 – £26,550.00
Power BI DAX Introduction£395.00 – £9,750.00
Power BI DAX Intermediate£395.00 – £9,750.00
Power BI DAX Advanced£395.00 – £9,750.00