# SYD

Returns the sum-of-years' digits depreciation of an asset for a specified period.

## Syntax

```
SYD(<cost>, <salvage>, <life>, <per>)
```

### Parameters

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). |

per | The period. Must use the same units as life. Must be between 1 and life (inclusive). |

## Return Value

The sum-of-years' digits depreciation for the specified period.

## Remarks

SYD is calculated as follows:

$$\text{SYD} = \frac{(\text{cost} - \text{salvage}) \times (\text{life} - \text{per} + 1) \times 2}{(\text{life}) \times (\text{life} + 1)}$$

An error is returned if:

- life < 1.
- per < 1 or per > life.

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

## Examples

Data |
Description |
---|---|

\$30,000.00 | Initial cost |

\$7,500.00 | Salvage value |

10 | Lifespan in years |

### Example 1

The following DAX query:

```
EVALUATE
{
SYD(30000.00, 7500.00, 10, 1)
}
```

Returns an asset's sum-of-years' digits depreciation allowance for the first year, given the terms specified above.

[Value] |
---|

4090.90909090909 |

### Example 2

The following DAX query:

```
EVALUATE
{
SYD(30000.00, 7500.00, 10, 10)
}
```

Returns an asset's sum-of-years' digits depreciation allowance for the tenth (final) year, given the terms specified above.

[Value] |
---|

409.090909090909 |

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for