07-17-2020 22:30 PM - last edited 07-17-2020 22:32 PM
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.
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.