PMT - Monthly - EMI Calculator

amitchandak — Sat, 18 Jul 2020 05:32:56 GMT

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

Re: PMT - Monthly - EMI Calculator

04turndan — Fri, 30 Sep 2022 16:36:35 GMT

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

topic PMT - Monthly - EMI Calculator in Quick Measures Gallery

PMT - Monthly - EMI Calculator

Re: PMT - Monthly - EMI Calculator