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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors