SLN is a DAX function that returns the straight-line depreciation of an asset for one period.
SLN(
Cost,
Salvage,
Life
)| Argument | Properties | 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 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 |
Other functions related to SLN are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy