📄ACCRINTM

Calculates the accrued interest on a security (like a bond) that pays all its interest at the maturity date. In simpler terms, it figures out how much interest you`ve earned on that bond up to a specific point in time, without waiting until it matures.

It takes five arguments:

Issue date: The date the bond was issued.
Maturity date: The date the bond matures and you get your money back.
Annual coupon rate: The interest rate the bond pays each year (usually a percentage).
Par value: The face value of the bond, which is what you get back at maturity.
(Optional) Basis: This tells the function how to count the days between dates. The default is 0 (US basis), but there are other options.

Things to keep in mind:

- Dates are stored as numbers in DAX, so the function uses those for calculations.
- The issue and maturity dates are rounded down to whole numbers.
- This function isn`t ideal for bonds that pay interest periodically (like monthly).
- It`s not supported for use in certain scenarios, like with DirectQuery mode in Power BI.

Application: