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, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors