DDB DAX Function (Financial)
Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
Syntax
Parameter | Attributes | Description |
---|---|---|
Cost |
The initial cost of the asset. |
|
Salvage |
The value at the end of the depreciation (sometimes called the salvage value of the asset). |
|
Life |
The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset). |
|
Period |
The period for which you want to calculate the depreciation. Period must use the same units as life. |
|
Factor | Optional |
The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). |
Return values
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/ddb-function-dax