Financial

ISPMT is a DAX function that calculates the interest paid for a specified period of a loan with even principal payments. Syntax Argument Properties Description Rate … Read More

TBILLYIELD is a DAX function that returns the yield for a Treasury bill. Syntax Argument Properties Description Settlement The Treasury bill’s settlement date. The security settlement … Read More

TBILLPRICE is a DAX function that returns the price per $100 face value for a Treasury bill. Syntax Argument Properties Description Settlement The Treasury bill’s settlement … Read More

INTRATE is a DAX function that returns the interest rate for a fully invested security. Syntax Argument Properties Description Settlement The security’s settlement date. The security … Read More

EFFECT is a DAX function that calculates the effective annual interest rate from a nominal rate and compounding periods. Syntax Argument Properties Description Nominal_rate The nominal … Read More

TBILLEQ is a DAX function that returns the bond-equivalent yield for a Treasury bill. Syntax Argument Properties Description Settlement The Treasury bill’s settlement date. The security … Read More

FV is a DAX function that calculates the future value of an investment based on a constant interest rate and periodic payments. Syntax Argument Properties Description … Read More

PRICE is a DAX function that returns the price per $100 face value of a security that pays periodic interest. Syntax Argument Properties Description Settlement The … Read More

DURATION is a DAX function that returns the Macauley duration for a bond, measuring its sensitivity to changes in yield. Syntax Argument Properties Description Settlement The … Read More

RECEIVED is a DAX function that returns the amount received at maturity for a fully invested security. Syntax Argument Properties Description Settlement The security’s settlement date. … Read More