Forum Discussion
running total for each year
Hi Gurus, Im just a newbie, i wanted to get a running total using a power query. i have a po and dates for each po. how can i achieved the result with running total for each po with respect to thei...
va bene così?
hello again.. it works but it doesn't separate the po running total to respected year..
| PO | Date | value | running total |
| AAA-1 | Jan. 1, 2020 | 200 | 200 |
| AAA-1 | Feb. 2, 2020 | 300 | 500 |
| 500 (total for 2020) | |||
| AAA-1 | Apr. 20, 2021 | 500 | 500 |
| AAA-1 | Dec.2, 2021 | 100 | 600 |
| 600 (total for 2021) | |||
| BBB-1 | Mar. 3, 2020 | 200 | 200 |
| 200 (total for 2020) | |||
| BBB-1 | Aug. 5, 2021 | 1000 | 1000 (total for 2021) |
devi scegliere se rimuovere la colonna PO o PO.1