VDB DAX Function (Financial)
Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.
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). This value can be 0. |
|
| Life |
The number of periods over which the asset is depreciated (sometimes called the useful life of the asset). |
|
| Start_period |
The starting period for which you want to calculate the depreciation. Start_period must use the same units as life. |
|
| End_period |
The ending period for which you want to calculate the depreciation. End_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). |
| No_switch | Optional |
A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation. |
Return values
Last update: Nov 5, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/vdb-function-dax