Guys, I need helpdoing one thing on Power Query, and I already tried a lot of ways, but noneseems to do what I need.
I have an amount,and I need to plot a chart with the sum of all amounts, divide by the terms,during the period of the terms.
For instance, inNovember 2017 it would be $ 1500 (18000/12). In December 2017 it would be $7750 ($ 1500 2nd installment + $6250 1st installment).
The table with theamount, start date and period will be updated very often. I put an example below, but you can imagine the problem when there are thousands of registers, and hundreds of new ones every month.
Do you know a way toautomatically calculate the total amount for each month so I can plot a chart?
<tbody>
</tbody>
I have an amount,and I need to plot a chart with the sum of all amounts, divide by the terms,during the period of the terms.
For instance, inNovember 2017 it would be $ 1500 (18000/12). In December 2017 it would be $7750 ($ 1500 2nd installment + $6250 1st installment).
The table with theamount, start date and period will be updated very often. I put an example below, but you can imagine the problem when there are thousands of registers, and hundreds of new ones every month.
Do you know a way toautomatically calculate the total amount for each month so I can plot a chart?
Amount | StartDate | Term |
18000 | 25/11/2017 | 12 |
50000 | 20/12/2017 | 8 |
30000 | 25/03/2018 | 4 |
36000 | 14/06/2018 | 5 |
33000 | 16/07/2018 | 11 |
60000 | 03/08/2018 | 10 |
<tbody>
</tbody>