Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589

Learn how to Create a Running Count for Product Names using the Grouping and Add Index Feature. Learn how to edit your M Code. See the Power Query functions: Table.AddColumn, Table.Group, Table.AddIndexColumn and Table.Combine. This trick is a method that can calculate more quickly than the method seen in Excel Magic Trick 1588. This trick comes from our YouTube Teammates Vida and Bill Szysz.

[josevaldesv]

I had read several pages and watched many videos, and this was the one that I understood more easily, and that was straight forward so that I could apply it to my own columns and names. Amazing!

[cemtekesin]

This is Gold! You also save column types from your previous step unlike other methods that out there. Thank you for sharing this!

[wayneedmondson]

Wow.. more PQ magic from Bill, Vida and Mike. Thanks guys! Thumbs up!!

[daviddecastro]

Great stuff Mike! Punchy content as always. Cheers

[BillSzysz]

Thanks, Mike :-)) Full professional, as always !!!

[danilochavez]

You are taking PQ to a higher level! Thanks!

[SupernaturalVRisFun]

Thank you Mike. It worked beautifully.

[ruelformales]

that was beautiful! Thank you so much! - subscribed!

[ogwalfrancis]

Power Query, the number one data analysis power from Microsoft, Thanks You Mike

[RajaMaja-zkdz]

Exactly what I'm looking for. Thanks Mike

[evgeniachubata]

Great video! Besides running count of the product names, this technique can also be used to find the duplicates in a list of names.

[GeertDelmulle]

Yes, this must be the most efficient way of doing this — there’s no duplication and subsequent filtering of data this time.
That Group+each combo filters the “_”-table (which is the table in the previous step) with something that reminds me of row context, and —of course— Group iterates over the resulting table, where the granularity is given by a VALUES (or is it UNIQUE? :-) of the column in the first argument (of the Group function). There’s a lot going on here. I don’t see any redundancy in the computations. Arguably, you could say that you group (aggregate) and subsequently expand the data again, which could be seen as unnecessary, but I don’t see how to avoid that, since it’s in the grouped state that you need to add the index.
Thanks to all three of you for the combined knowledge sharing on this one!

[vida]

I like your faster way when you combine several functions into one step . P.S. second letter of my name is pronounced like 'e'

[vinhwizard]

Wow, this way is easier than before (1588). Thanks teacher

[jimfitch]

Eventually, I come up with a use case for techniques that you teach, Mike. I saw this months ago, but had my first use case today. Thanks to your expert content curation, I found exactly what I needed in no time. (As often as not, I search YouTube in your channel before trying a broader Internet-wide search.) Once again, thank you, expert teacher!

[ExactProBi]

Great solution mike, I think you and Bill should do a video series on YouTube for Advanced Power Query!

[simfinso]

Oh Super.I need to watch Your all power Query Videos From Basic of power Query.

[francoistheron]

Thanks Mike for this very helpful video.
I used your other Magic Trick with the Inside and Outside Tables as I had to count the number of occurrences of an object located in column A in another column B (how many times does the object X from column A appear in column B from range 1 to object X position).
I assume that for this case where the running count is operating in a different column, the IT and OT functions are the most suitable (albeit very calculation intensive) right?

[blacksheep]

Thanks Mike, do you have a similar tutorial for count opposite using power query? Looking to replicate what you did for the match positive and negative balance tutorial in excel using power query.

[franciscom.paredesarias]

Thanks a lot for sharing, I'm pretty busy knowing how many duplicates I have on a table