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.
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 |
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |