Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
ivandgreat
Helper II
Helper II

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 their dates.

 

PODate (Month/Day/Year)ValueRunning Total

AAAA-1

1/1/2020100100
AAAA-12/1/2020200200
 Total Year End 2020 300

BBB-2

4/1/2020400400
BBB-26/1/2020100500
 Total Year End 2020 500

BBB-4

7/1/2021100300
BBB-410/1/2021500800
 Total Year End 2021 1100
1 ACCEPTED SOLUTION
Anonymous
Not applicable

7 REPLIES 7
ivandgreat
Helper II
Helper II

Hi again,

 

still something is not correctly separated from its year.

 

image.png

 

Also, how can i make the date as month or its possible to have a running total with respect to its month and po .. 

Thanks again.

Anonymous
Not applicable

Questa è una situazione diversa da quelle specificate da te nel primo messaggio.

Anche la situazione di più anni per lo stesso PO può essere gestita con una modifica dello script che ho proposto.

Ma adesso non ho tempo per farlo (anche se non ci vuole molto) perché devo cucinare 😋.

se qualcuno non posta prima la soluzione, ci ritornerò appena posso.

 

PS

probabilmente queste cose sono più semplici da fare in DAX non usando M.

Still struggling how to do in using power query or DAX.

Please your kind support how can able to show it as per required. Thank you

Anonymous
Not applicable

va bene così?

Anonymous
Not applicable

 

hello again.. it works but it doesn't separate the po running total to respected year..

 

PODatevaluerunning total
AAA-1Jan. 1, 2020200200
AAA-1Feb. 2, 2020300500
   500 (total for 2020)
AAA-1Apr. 20, 2021500500
AAA-1Dec.2, 2021100600
   600 (total for 2021)
BBB-1Mar. 3, 2020200200
   200 (total for 2020)
BBB-1Aug. 5, 202110001000 (total for 2021)
Anonymous
Not applicable

devi scegliere se rimuovere la colonna PO o PO.1

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.