Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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)
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)
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |