Hi
Can someone explain or direct me to where I can find out how to create a running total in power query where there is a condition ,
or by date.
I've attached a sheet containing 2 tables with what I'd like to achieve in power query. having watched one tutorial i have feeling it's not straight forward.
If someone can direct me to information on the 'why' and 'how' rather than just copying a set of instructions than would be a help.
Richard.
Perhaps the linked video tutorial will help: Running totals by subcategory in Power Query!!
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you JeteMc,
I have actually watched this one, in fact it's about the only one I've found.
RD
Perhaps this will be of more help.
This video is produced by Mike Girvin an instructor at Highline College: https://www.youtube.com/watch?v=EP4L1FVcSUg
Below the video are some links to files. If you choose the "Download Excel Finished File" then you can see the M Code written for the RT and RTM columns
In the video the explanation for producing the Power Query table starts at the 5:18 mark.
Here is another video on grouping using power query that was recommended by youtube: https://www.youtube.com/watch?v=uvOX-Oy-Zdk
Thank you Jete. I'm actually a big fan of Mike Girvin, and yes it does work but A the use of the underscore to refer to the table isn't that gone into though
I know on MSPTDA 09 he does go into more detail.
I had not come across FranzSheikh and this was much more what I was after. I'll have a look at some of his other vidieos.
Thanks again.
RD
Last edited by Dicken; 01-10-2022 at 08:12 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks