SLN
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the straight-line depreciation of an asset for one period.
SLN(<cost>, <salvage>, <life>)
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). |
life | The number of periods over which the asset is depreciated (sometimes called the useful life of the asset). |
The straight-line depreciation for one period.
An error is returned if:
life = 0.This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Data | Description |
---|---|
$30,000 | Cost |
$7,500 | Salvage value |
10 | Years of useful life |
The following DAX query:
EVALUATE
{
SLN(30000, 7500, 10)
}
Returns the yearly depreciation allowance using the terms specified above.
[Value] |
---|
2250 |