Forum Discussion

mnada80's avatar
mnada80
Regular Visitor
6 years ago
Solved

Calculate monthly installment

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 mu...
General Comment
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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)

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

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)