Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hey for [Months] what formula did you use?
I'm trying to used Selectedvalue but it's not giving me the same results as you.
Thanks