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