What is the ACCRINTM Function?

The ACCRINTM function is a financial function in Power BI that calculates the accrued interest for a security that pays interest at maturity. This function takes into account the issue date, maturity date, and interest rate of the security to calculate the accrued interest.

How to Use the ACCRINTM Function

Using the ACCRINTM function in Power BI is easy. First, you will need to have a table that contains the following information:

– Issue Date: The date the security was issued

– Maturity Date: The date the security matures

– Interest Rate: The interest rate of the security

Once you have this information, follow these steps:

1. Insert a new column into your table by selecting the table and clicking on “New Column” in the “Modeling” tab.

2. In the formula bar, enter the following formula: =ACCRINTM([Issue Date], [Maturity Date], [Interest Rate])

3. Press enter to calculate the accrued interest for each row in your table.

Example

Let’s say you have a table called “Securities” that contains the issue date, maturity date, and interest rate of various securities. To calculate the accrued interest for each security, follow these steps:

1. Select the “Securities” table and click on “New Column” in the “Modeling” tab.

2. In the formula bar, enter the following formula: =ACCRINTM([Issue Date], [Maturity Date], [Interest Rate])

3. Press enter to calculate the accrued interest for each row in the “Securities” table.

The resulting column will contain the accrued interest for each security in your table.

The Power BI DAX function ACCRINTM is a powerful tool for financial analysts who need to calculate accrued interest on securities that pay interest at maturity. By following the steps outlined in this article, you can easily incorporate the ACCRINTM function into your Power BI reports and streamline your financial analysis.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us