📄ACCRINT

The ACCRINT function in DAX is like a calculator for figuring out how much interest you`ve earned (Accrued interest) on an investment that pays out regularly, like bonds.

It works by considering several factors:

Investment details:

Issue date: When you bought the investment
First interest date: When the first interest payment is scheduled
Settlement date: When you sell or redeem the investment
Par value: The initial face value of the investment
Coupon rate: The interest rate paid per coupon period (usually annually, semi-annually, or quarterly)

Optional details:

Basis: A method for calculating the number of days in a year (e.g., 30/360 or actual/actual)
Calculation method: Decides if interest is accrued from the issue date or the first interest date (default is from issue date)

ACCRINT takes all this information and calculates the total interest you`ve earned up to the settlement date.

It`s important to note that ACCRINT has some limitations:
It only works for investments with periodic interest payments.
It`s not recommended to use the basis or calculation method arguments anymore.
It`s not supported for use in certain scenarios like DirectQuery mode.

For simpler calculations, there`s also a similar function called ACCRINTM, which is specifically for investments that mature with interest.

Application: