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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors