SYD is a DAX function that returns the sum-of-years’ digits depreciation of an asset for a specified period. Syntax Argument Properties Description Cost The initial cost … Read More
DISC is a DAX function that returns the discount rate for a security. Syntax Argument Properties Description Settlement The security’s settlement date. The security settlement date … Read More
VDB is a DAX function that returns the depreciation of an asset for any specified period using the variable declining balance method or another specified method. … Read More
CUMPRINC is a DAX function that returns the cumulative principal paid on a loan between a start period and an end period. Syntax Argument Properties … Read More
DDB is a DAX function that returns the depreciation of an asset for a specified period using the double-declining balance method or another specified method. … Read More
SLN is a DAX function that returns the straight-line depreciation of an asset for one period. Syntax Argument Properties Description Cost The initial cost of the … Read More
CUMIPMT is a DAX function that returns the cumulative interest paid on a loan between a start period and an end period. Syntax Argument Properties … Read More
DB is a DAX function that returns the depreciation of an asset for a specified period using the fixed-declining balance method. Syntax Argument Properties Description … Read More
YIELD is a DAX function that returns the yield on a security that pays periodic interest, typically used to calculate bond yield. Syntax Argument Properties Description … Read More
YIELDDISC is a DAX function that returns the annual yield for a discounted security. Syntax Argument Properties Description Settlement The security’s settlement date. The security settlement … Read More