In July 2020 release Power BI has released 49 financial functions. One of them in PMT.
This function is used to calculate Monthly EMI -
As per DAX documentation: Calculates the payment for a loan based on constant payments and a constant interest rate.
https://docs.microsoft.com/en-us/dax/pmt-function-dax
It requires - Annualized Rate (In Percent), Number of Period/Installments, and the Principal Amount.
In Power BI, we do not have input boxes and What-if Parameter is limited by max value. I have created a few series, to get this done. This means you can give the principal only in the multiple of 10,000 .
Monthly EMI = -PMT([Rate]/(12.0*100),[Months],[Principal])
I have taken an absolute number for percent, that is why I am dividing it by 100.
You can enter the amount by clicking in the box and tab out.
eyJrIjoiZGE2YjQxNTgtNzYyZC00OWNiLTgzNGMtNGIwN2U5N2ZmMGNlIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9
Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
✨️ November 12th-14th, 2024
Online Event
Register Here
