Forum Discussion
Cumulative Values using Power Query and having a Date Restriction
I have the following table and i would like to caclulate running totals using Power Query.
| ID | Value | Date | Max Date |
| A31 | 2 | 21/01/2018 | 31/10/2018 |
| A31 | 3 | 10/02/2018 | 31/10/2018 |
| A31 | 6 | 15/03/2018 | 31/10/2018 |
| A32 | 1 | 10/01/2018 | 31/12/2018 |
| A32 | 9 | 14/02/2018 | 31/12/2018 |
| A32 | 6 | 26/03/2018 | 31/12/2018 |
I want the running total to run up to the Date specfified by the Max Date field.
The output table based on the above data will look like this. I know how to do this on DAX but I want this the same output using Power Query:
| Month | ID | Cumulative Values |
| Jan-18 | A31 | 2 |
| Feb-18 | A31 | 5 |
| Mar-18 | A31 | 11 |
| Apr-18 | A31 | 11 |
| May-18 | A31 | 11 |
| Jun-18 | A31 | 11 |
| Jul-18 | A31 | 11 |
| Aug-18 | A31 | 11 |
| Sep-18 | A31 | 11 |
| Oct-18 | A31 | 11 |
| Nov-18 | A31 | 0 |
| Dec-18 | A31 | 0 |
| Jan-18 | A32 | 1 |
| Feb-18 | A32 | 10 |
| Mar-18 | A32 | 16 |
| Apr-18 | A32 | 16 |
| May-18 | A32 | 16 |
| Jun-18 | A32 | 16 |
| Jul-18 | A32 | 16 |
| Aug-18 | A32 | 16 |
| Sep-18 | A32 | 16 |
| Oct-18 | A32 | 16 |
| Nov-18 | A32 | 16 |
| Dec-18 | A32 | 16 |
