Calculate monthly installment

[mnada80]

Dear Experts,

I am new in the whole analytic and need your help.

Let's assume I have multi able installment every month each installment with a different period I need to know every month how much I am going to pay start from this month till the end of the installment. 

the data looks like this 

Liability	Transaction Date	Purchase Description	Installment Amount	Installment count	Total Installment Period	Total Amount	Remaining amount	Pay Off Month
Visa	10/11/2019	Fridge	231.12	8	12	2,773	924.50	10/11/2020
Cash	10/04/2020	Money transfer	466.50	3	12	5,598	4,198.50	10/04/2021
Master	10/11/2019	TV	291.58	8	12	3,499	1,166.33	10/11/2020

I need to know how much  I am going to pay every month as total or per Liability 

Thank you very much 

also in Power BI desktop, it takes the currency from the calendar the new version of May 2020 I am not able to change the currency symbol.

[v-diye-msft · Accepted solution]

Hi @mnada80 

If I understand correctly, you should probably refer to the cumulative sum something like below:

Measure = CALCULATE(SUM('Table'[Installment Amount]),FILTER(ALL('Table'),[Pay Off Month]<=MAX('Table'[Pay Off Month])),VALUES('Table'[Month]))

Month is a calculated column:

Month = MONTH('Table'[Pay Off Month])

For the issue of change currency, I just tested it on side, and it works fine, I'm using the June version:

Version: 2.82.5858.641 64-bit (June 2020)