DAX financial functions: Depreciation calculations

 dans Sites anglophones  étiqueté aggregation / amortization / balance / BI / calculation / column / DAX / DB / DDB / declining / depreciation / Desktop / digits / double / Excel / fixed / format / function / Homepage / line / Power BI / PowerPivot / Report / SLN / SQL Prompt / straight / sum-of-years / summarize / SYD / table / total / visual / visualization par

 

The series so far:

DAX financial functions: Loan calculations DAX financial functions: Depreciation calculations

This article continues the introduction to the DAX financial functions begun in DAX financial functions: Loan calculations. As noted there, these 50-plus functions debuted around the time of the July 2020 release of Power BI Desktop; they are largely derived from those found in Excel, and so will seem familiar to many Excel users. In the first article, you gained exposure to a group of related loan- / investment-related functions. In this article, the focus will be upon another group, Depreciation and Amortization functions.

You’ll be