Forum

Running total in po...
 
Notifications
Clear all

Running total in power query

5 Posts
3 Users
0 Reactions
99 Views
(@ngocting87)
Posts: 2
New Member
Topic starter
 

Pls help me in power query

 
Posted : 30/03/2023 2:26 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Try these posts

Running totals in Power Query

Grouped Running totals in Power Query

Regards

Phil

 
Posted : 30/03/2023 2:48 am
(@ngocting87)
Posts: 2
New Member
Topic starter
 
I've seen it but it doesn't work, you can check the file
Column(G)=IF(E3>0,F3,SUM(N(+G$2:G2)))
 
Posted : 30/03/2023 3:59 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

If you actually try to provide detail about what it is and explain clearly the result you want, it'll be much easier to help you.

To start, in your workbook (and in your previous reply) you have an Excel formula.  This isn't M code, so I'm not clear on whether you want a Power Query solution, or to use an Excel formula.

Secondly, I can't see what is wrong.  Your formula is doing what it is written to do.  How exactly does the result it gives differ from what you want.

Thirdly, if you have seen the posts on running totals in Power Query (which do work) and tried the code, you haven't explained why they don't produce the result you are after.

Regards

Phil

 
Posted : 30/03/2023 8:42 am
(@debaser)
Posts: 836
Member Moderator
 

Also cross-posted here: https://chandoo.org/forum/threads/running-total-in-power-query.52167/

 
Posted : 30/03/2023 9:03 am
Share: