Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
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.
VDB(<cost>, <salvage>, <life>, <start_period>, <end_period>[, <factor>[, <no_switch>]])
Term | Definition |
---|---|
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 being 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. Must be between 1 and life (inclusive). |
end_period |
The ending period for which you want to calculate the depreciation. End_period must use the same units as life. Must be between start_period and life (inclusive). |
factor |
(Optional) The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). Change factor if you do not want to use the double-declining balance method. For a description of the double-declining balance method, see DDB. |
no_switch |
(Optional) A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation. If omitted, it is assumed to be FALSE . - If no_switch evaluates to TRUE VDB does not switch to straight-line depreciation, even when the depreciation is greater than the declining balance calculation. - If no_switch evaluates to FALSE or is omitted, VDB switches to straight-line depreciation when depreciation is greater than the declining balance calculation. |
The depreciation over the specified period.
An error is returned if:
TRUE
or FALSE
.This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Data | Description |
---|---|
2400 | Initial cost |
300 | Salvage value |
10 | Lifetime in years |
The following DAX query:
EVALUATE
{
VDB(2400, 300, 10*365, 0, 1)
}
Returns an asset's first day's depreciation using a factor of 2.
[Value] |
---|
1.31506849315068 |
The following DAX query:
EVALUATE
{
VDB(2400, 300, 10*12, 6, 18, 3)
}
Returns an asset's depreciation between the 6
[Value] |
---|
540.185558199698 |
The following DAX query:
EVALUATE
{
VDB(2400, 300, 10, 0, 0.875, 1.5)
}
Returns an asset's depreciation in the first fiscal year that you own it, assuming that tax laws limit you to 150% depreciation of the declining balance. The asset is purchased in the middle of the first quarter of the fiscal year.
[Value] |
---|
315 |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today