MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)

Download Excel START Files:
people.highline.edu/mgirvin/A...
Download Excel FINISHED Files:
people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: people.highline.edu/mgirvin/A...
Assigned Homework:
Assigned Homework:
Download Excel File with Homework: people.highline.edu/mgirvin/A...
Example of Finished Homework: people.highline.edu/mgirvin/A...
Buy excelisfun products:
teespring.com/stores/excelisf...
In this Video learn all about Power Query’s Group By feature. See Four Examples of how to use Group By to Calculate Total Sales, Standard Deviation, Join Names and Rank Sales.
Topics:
1. (00:15) Introduction
2. (01:30) What Does Power Query Group By feature do?
3. (02:58) Examples of PivotTable, SUMIFS, Data Model PivotTable and SQL Code to see that Power Query Group By is VERY Similar
4. (05:55) Example of Simple Power Query Group By Command for Total Sales
5. (08:50) First Look at Table.Group Power Query Function
6. (10:17) Example of using Group by to get Tables of Grouped Records, or Matching Records
7. (11:55) Standard Deviation Custom Column Based on Grouped Records Table
8. (14:41) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table
9. (16:23) Detail look at Table.Group Function. Edit and create arguments in Third Argument to List Multiple New Columns with Formulas
10. (21:32) Power Query Group By to Help Rank Sales for Each Product
11. (26:24) Group By More Than One Column
12. (27:11) Fast Trick for Group By: Placeholder Function
13. (28:51) Add new data and see that everything updates.
14. (29:38) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

[@AkaExcel]

Person who dedicated his life to Excel. World Teacher!

[@excelisfun]

Yes, I am happy to be a World Teacher of such a fun topic!!!! Thanks, for your support, Learn Excel : )

[@AbrasionUK]

Best Excel teacher on KZbin. You got yourself a subscriber!

[@excelisfun]

Glad to help with the teaching, David!!!

[@shylomathew]

No words to express my gratitudes... ! Fully agree with Rodrigo Custodio - "...you are definitely contributing to the development of human capital all over the world"

[@michaelmaharlika8569]

Mike, After lesson 7 I joined your channel to say thank you for helping me to better understand these features, great teaching. Michael

[@excelisfun]

I am happy that my videos can help!!!!

[@MukeshKumar-vc6hl]

I am really addicted to your tips, tricks, shortcuts and formula explanations. I learned from videos for 12 years and am still learning. And that's why I have never had any difficulty in solving any Excel problem. Love from India 😍❤💞

[@tableaupro3233]

Mike, wow! What an excellent video! 1. When I saw the title Group By, I was thinking of skipping the entire video as there is not much new that can be said about group by - that is what I thought. Then, I checked out the notes and found the mention of 'All Rows' intriguing. It has been a few years since I have first tried PQ when it was an add-in for Excel 2013. I have never realized that I could programatically manipulate the filtered records so easily in PQ. So, I decided to watch the video - Another wow! What a wonderful set of examples that made me feel "I need to really try this to really understand this at a deeper level". I am amazed at ingenious design of the concept of a cell in PQ that it can hold a list or table and we can recursively work on it - This is the first material new info for me about PQ in these many years, except for what I have learnt on my own by exploration. And you sparked my curiosity to learn 'M' which so far I ignored as I felt that it would not give me enough ROI for time invested in learning it, given that so much is possible through mouse-clicks! 2. Returning a comma-separated list of unique values is a very hard job in any BI tool. Glad to have CONCATENATEX in DAX and List.Combine in PQ - Wow !

[@excelisfun]

If you learn a lot of new things in this video, you are NOT going to believe the next few videos culminating in video #9 : ) : ) I am so glad that these videos help. I just wish i could figure out how to point more people to these videos because for free content, they seem to just sort of languish with a few views here and there, but just never take off and reach all of the many people who would just LOVE to get free content like this... I really appreciate your support with your thoughtful and intriguing comments and Thumbs Ups on each video : )

[@tableaupro3233]

@@excelisfun Thanks Mike for sharing your concern that these videos are not reaching many people. Let me watch the entire MSPTDA series and then give you some ideas on how to take these videos to more people. The problem is that the commercial packages do a lot of marketing and in their noise, some of the very good free stuff gets drowned out.

[@excelisfun]

@@tableaupro3233 This series will continue until June, then it should be complete. So you have some time before this will be complete : )

[@davida.taylor8444]

@@excelisfun I've taught a few intermediate Excel trainings for my agency and I always include a link and a promo to your videos in the class. I know that some have watched it. I think, though, that material like this tends to be for people who specialize in data analysis which is a smaller sub-set of workers. But, as a result, I know that I've impressed my bosses and co-workers from using and demonstrating much of the stuff I learned from your channel...even got a significant promotion out of it.

[@excelisfun]

@@davida.taylor8444 I love to here that the videos help with work promotions and all, David A. Taylor!!! Thank you very much for supporting and sharing : )

[@tramle2705]

Best Excel teacher ever ❤You really made M Code so much easier to understand ^^ Thank u so much 😍

[@excelisfun]

You are welcome!!!!

[@janiswest2611]

Hi Mike I was quite direct below and as usual go back and realise that it looks stiff and ungrateful. Thank you so much for all your videos we love listening to your Accent as we learn.

[@danielwerner9543]

Great video, got lost editing the M code a couple times but stuck with it. Mike your a great teacher, I love your enthusiasm!

[@excelisfun]

I am glad to help : )

[@elactecnology]

Mike, there is no other way I could personally thank you for this wonderful training. I will comment over and over again, until the whole class of professional services (Audit, assurance and consulting) learn how to clean and transform a GL by power query. Thank you Mike for your wonderful classes.

[@excelisfun]

You are welcome for the wonderful class!!!! There is no doubt, Power Query is the greatest invention since the PivotTable : )

[@871340730]

Highly appreciate your generosity to share your top knowledge with an unseen audience! Thank you so much!

[@excelisfun]

You are welcome so much, Shehan!!!

[@mohitmanwani5298]

Ease of doing & learning Excel and Data Analysis with Mike is "THE BEST"

[@excelisfun]

Glad you like the videos, Mohit, and thank you for your support : )

[@alyismael91]

Learnt so much new in just 30 minutes. Never knew power query could do such much. A big thank you and thumbs up from Pakistan. :)

[@excelisfun]

I am glad that you learned a lot, Ali!!!! Thank you for the Big support with your comment, thumbs up and Sub : )

[@francismacisaac6972]

Wow, Pivot Table like functionally within Power Query, another golden moment.

[@excelisfun]

Glad it was golden for you, Francis!!!

[@rodrigocustodio1955]

Mike, I cannot find words of gratitude, thank you so much!!!!, you are the best for sure, you strategically breakdown complex tasks into manageable steps and later when all the steps are aggregated we are already mastering it. Thank you again, you are definitely contributing to the development of human capital all over the world. By the way, I am waiting for your next book !!!!!!

[@shoeshines2121]

In each video, there are so many nuggets of information. It's a wonderful thing with technology available to rewind the video, listen again, and really grasp a concept. An example in this video being that nifty way to use an Index Column to rank a dimension within a group. That was so cool!

[@excelisfun]

Glad that you like all the nuggets, TP!!!! Thanks for your consistent support with your cool comments and thumbs ups : ) Yes, the rewind button is VERY important on long gold mine videos, like this.

[@LeilaGharani]

Thank you Mike for this very informative lecture. Group by to rank is great!

[@excelisfun]

Glad you like it, teammate : ) Thanks for your support!!

[@mazarata73]

I really very much like seeing that Leila is following your youtube videos as well. She is a great tutor as well :-)

[@excelisfun]

Yes, Leila and I have been hanging out for years! We are part of the Excel Online Team and especially the Excel KZbinr Team!!!!!

[@LeilaGharani]

Thank you Giuseppe. Mike is the best! I've learnt (and still learning) so much from him & his books and been inspired by his videos & teaching :)

[@mazarata73]

Dear Leila, I know exactly what you mean. But trust me, your KZbin videos and Udemy courses are an excellent completion. Thank you.

[@johnwatson8203]

Mike I forgot how awesome you are! You started my journey of learning short-cut keys, you not only helped me but countless others that learned from you and spread the knowledge on! Thank you

[@excelisfun]

You are welcome!!! Great to see you are a CPA. I took my CPA exam back in the last event that we had to go to a stadium and sit in metal chairs for 10 each for two days, back in 2002. Just about that time is when some fellow accountants insisted that keyboards were the key to efficiency. Boy, were they right.

[@tomr9969]

Great session! Getting a first look at list. function is very powerful. I really liked the last one where you added the placeholder for standard deviation. Off to MSPTDA09!

[@excelisfun]

Yes, placeholders are so convenient. The video I posted yesterday, we used multiple placeholders in the transformation: kzbin.info/www/bejne/nKecq6Z8e82EfaM

[@excelisfun]

But actually, MSPTDA 09 inroduces all the M Code technicalities, so it is best to watch that first, but the 7 minute quickie that i posted yesterday (link in other comment) is a fun one...

[@excelisfun]

Thanks for your support Tom R!

[@lauracru]

I'm trying to extract the end balance from an export based on criteria general ledger #, date. My difficulty is there are numerous daily transactions and I need to pull the final ending balance for the specified date and gl#. I've searched the whole internet trying to accomplish this task lol. I think this video holds the key, but I don't know what I'm missing. Thank you for all you've taught me over the years, you're truly a credit to educators everywhere!

[@jakariahabib1062]

I am really grateful to you. I can't believe this whole lot of videos are free!! Already liked & subscribed.

[@excelisfun]

Glad the content helps. Thanks for your support, Jakaria : ) : )

[@baselbargothi3410]

I don't have any words to describe how much I appreciate this work, Only I can say THANK YOU !!!!!!

[@excelisfun]

You are welcome! You can appreciate the free knowledge with a comment and thumbs up on each video. Good deal, right ; )

[@baselbargothi3410]

@@excelisfun I will :)

[@Softwaretrain]

Mike you are the best teacher. I learned alot from you. Thanks.

[@excelisfun]

You are welcome a lot! Thanks for your support with your Thumbs Ups, Comments and Sub : )

[@jazzista1967]

Mike. This was a PQ master class. Great examples. Thanks for sharing.. Keep the MSPTDA coming.

[@excelisfun]

It will keep coming - there will be about 1 to 2 videos a week for the next nine months. It takes a huge amount of time to create, so it will be slow coming - but it may be the most fun we have ever had here at excelisfun!!! Thanks for the consistent support on each video, jazzista 1967!!!!!

[@rrrprogram8667]

ExcelIsFun Wowwwww... 9 monthssssss.... Just FANTASSSSTICCCCCCC

[@excelisfun]

Yes, Much more fun to come!!!!

[@amerfarooq1142]

Mike, I don't have as great word as great your work is to gratitude, thank you so much

[@excelisfun3903]

You are welcome so much!!!

[@huynhdinhtuananh]

Firs-time to learn M-Language, But it fun and attractive thanks to Mike. Loving all your course online.

[@excelisfun]

Yes, M Code brings real power to what we need to do in Excel : )

[@Muuip]

Role model for online tutorials of any kind. Great very useful Excel/Power Query informations. Many thanks!

[@cristian.angyal]

Just learned new trick with List.XXX inside a column aggregated with All records. Thank you Mike!

[@excelisfun]

You are welcome!

[@TracyGraham13]

This lesson was life-changing! Looking so forward to continuing this class. I'm learning so much with each one.

[@excelisfun]

Glad the classes help, Tracy!

[@GeertDelmulle]

World Class Series, Mike, beautiful and instructive. Also, thanks for pointing out that although the PQ interface is really helpful and lowers the M-learning curve by a lot, it is not perfect and most definately not complete. So, the place-holder-swap technique comes in handy to deal with the obligatory syntax constraint. And finally: Yes, the MS taxonomy of M-functions is a good browser short cut to have at hand. See you on the next one.

[@excelisfun]

Yes, placeholder is a good trick : ) Can't wait for the next one myself! See you then.

[@zeshanful]

thank you mike for the video. your contribution is remarkable and dont have words to thank you for your effort

[@iwantovani3727]

Mike, thanks for sharing this video. I have watched this and repeat it many times until I fully understand "Group by" feature in Power Query. It's very helpful to me, saving a lot of time to get my job done! I have put thumb up on this video.

[@ForgottenBeastMetal]

I really appreciate how well you explain things. Great job! The multiple Group by columns with All Rows was a HUGE help for me thank you!

[@excelisfun]

You are welcome, Pete!

[@nishantkumar9570]

Awesome! Lots of knowledge in one single video. You are amazing!

[@excelisfun]

Yes, lots of fun all in one video !!! Thanks for watching, Nis 007, and thanks for your support with comment and Thumbs Up : )

[@nishantkumar9570]

ExcelIsFun can't wait what's next in this series.

[@excelisfun]

Hopefully two video next week : )

[@hansluderer3493]

Oh wow I can change the data type on multiple columns. Game changing!

[@kosalanef]

Thank you very much again for sharing your knowledge... I loved to read comments on how people appreciate the work. It means a lot to all the people...(but still, asshols are there who dislike).... The amazing this is you find time to respond to all most all the comments.... Respect you!

[@ashishsharma6916]

Hi Sir, thanks a lot, i am from India, your way of teaching is best, i have learned a lots of things from your videso,.

[@excelisfun]

I am glad that my teaching helps : ) : )

[@janwillemvanholst]

Hadley Wickham (R packages) speaks of split-apply-combine to describe group-by. Concise and insightful.

[@excelisfun]

I like it: Split, Apply, Combine!!!!! Thanks for the insight : ) And thanks for your support, Jan !

[@sherryizzie5309]

Many thanks for the amazing video, Mike. Never thought you can use group by function to do so many calculations!

[@excelisfun]

You are welcome, sherry!!!!! Thank you for your support : )

[@knikl]

This is great stuff Mike, I didn't PQ could do that. I am really enjoying the MSPTDA videos :) thank you from Sydney

[@excelisfun]

You are welcome down in Sydney from here is US : ) Thanks for your support, knikl!!!!

[@himanshudalai1028]

This is really awesome. So beautifully explained the concept. Thank you so much Mike. Awaiting with bated breath the next video in this series.

[@excelisfun]

Glad it is good for you, HIMANSHU!!! It takes a long time to make a video, pdf files, Excel Fiels and Practice Problems - this video took me about a week. So it should be by next weekend that the next one will be out. The good news is that I have plans for the next 9 months to post videos in this series - about 1 - 2 videos a week : ) Thank you for the support.

[@mazarata73]

Great tutorial once more. Thank you so much for the cristal clear paths to solutions. Ranking with group by is a cool idea!

[@excelisfun]

You are welcome for the crystal clear fun, Giuseppe!!!

[@edwardholley3179]

These videos are amazing, love how they cater for total newbies like me and for more advanced users. The explanations on the coding are particularly useful :)

[@excelisfun]

You are welcome, Edward!!!! Thanks for the support with your comments, Thumbs Ups and your Sub : )

[@mattschoular8844]

Text.Combine Are you kidding me? I have been trying to figure that out in Access forever. This is making me re-evaluate my work flow processes. Thanks Mike

[@excelisfun]

You are welcome, Matt!!! I thought I already did Text.Combine in this series, I even said that in the video... Maybe it was an Excel Magic Trick where I use it... Anyway, yes, Power Query has a function for almost everything - Access, Excel, DAX are not even close... Thank you for your support on each video, Matt!!! : )

[@KR-good]

Hi Mike. Just last week I had a project with an ungodly amount of unpivoting. I would generally do this in SQL, but was able to do it in seconds via PQ. Just wanted to thank you again for your awesomeness.

[@excelisfun]

You are welcome! I am so glad that the videos and other material help! Thank you for the support with your comment, Thumbs Up and Sub : )

[@user-ct2og8ku2u]

Мацк объясняет последовательно и обстоятельно. Лучший курс по PQ. Одновременно подтягиваешь знания кода М, синтаксис формул, и общие принципы обработки данных. Такой подход позволяет быстро освоить инструмент - ты не просто зазубриваешь готовые решения, но и знаешь как их применить в различных ситуациях. Очень рекомендую автора и благодарю его

[@vida1719]

Such a great explanation with several options to achieve the same result

[@excelisfun]

Glad you like the explanation, Vida!!!! Thanks for your support : ) And, yes, the last way with a Placeholder Function is fast and easy : )

[@mohamednofal4725]

Thanks so much for such an amazing lesson. always grateful for your effort

[@excelisfun]

I am happy to post and help you and the rest of our Team! Thanks for stopping by in the comments, mohamed!!!

[@kebincui]

Thanks Mike so much for this amazing Grou-By tutorial👍👍👍

[@excelisfun]

You are welcome for the Group By : )

[@MalinaC]

Grouping.... and you can do so much with it! Wow! Thank you for sharing, Teammate :)

[@excelisfun]

Yes, Group By is very useful! You are welcome, Teammate!!

[@timwhite8952]

Thanks for the video. I will have to watch it again to fully grasp the concepts. Really enjoying this series.

[@excelisfun]

Glad you are enjoying the series, Tim! Thanks for your support : )

[@sasavienne]

Thanks Mike. 👍 The 'all rows' functionality in the group by area in power query is exactly the same as the drill down function in pivot tables...

[@sukoi2113]

much needed video/ knowledge i am looking for. Thank You very much!

[@CMdJafar]

Thank you so much, Mike. I added an additional function , List.Sort as well, so I can the display SalesRep in the Ascending Order. This topic was a little bit difficult for me, but I am practising a lot to understand where can I apply this functionality in my work. Thanks again Mike. = Table.Group(#"Changed Type", {"Product"}, {{"Total Sales", each List.Sum([Sales]), type nullable number}, {"StandardDeviation S", each List.StandardDeviation([Sales]), Currency.Type} , {"WhoSoldTheProduct", each Text.Combine( List.Sort(List.Distinct([SalesRep])),", "), type text}})

[@JJMasterDigital]

Thanks, Mike. It's very nice to know Power Query can edit table inside table with Add Custom Column or by Grouping. We can access cell inside a column in table by Table.AddColumn(#"Grouped Rows", "FirstCell", each [All Rows][Index]{0})

[@Chris_in_fremantle]

Incredible! Mind Blown. Thank you Mike.

[@excelisfun]

Glad your mind is blown in a great ans fun way, Chrisinfreo!!! Thank you for the support with your comment, Thumbs Up and Sub : )

[@ismailismaili0071]

thank you so much Mr. Mike this is an awesome series to me because it's full of new things thank you again

[@excelisfun]

You are welcome again, Ismail!!!! Thank you for your kind and consistent support : )

[@danieltoupin4949]

Great class, well explained... and with context and relation with pivot table

[@kamranb1369]

Wow, simply amazing Mike, I loved the part when you did all the steps in single line of code :-) & MSPTDA is great & the best course on power query.

[@excelisfun]

So glad it is amazing for you, K B!!!! It is amazing fun for me too : ) Be sure to tell all your friends that MSPTDA is lots of fun : ) Thanks, K B!!

[@kamranb1369]

I already tell my friends about how great this channel is Mike :-)

[@excelisfun]

That is great!! Thank you, K B, for helping to spread the word : ) : )

[@chrism9037]

Another awesome Power Query video, thank Mike!

[@excelisfun]

You are welcome, Chris!!! Thanks for the support : )

[@yekhtiari]

This is really awesome. I must watch it one more time.

[@iankr]

Wow, this is excellent stuff. Many thanks. Like me, you're a big fan of keyboard shortcuts, using the mouse as little as possible.

[@excelisfun]

In all 3,300+ videos I have posted, it is all about the efficient keyboards ; )

[@nimanitto]

Thanks for your wonderful videos, Mike!

[@excelisfun]

My pleasure!

[@rrrprogram8667]

When we have teachers like you... There is absolutely no need of anyyyyy books..and also be the class topper... Lately i am doing lots of Rstudio... Only to realise the quality of ur teaching and explanations are beyond gold treasures.. None of the other channels are even close to ur quality and content..

[@excelisfun]

If that is true, then why do my videos have so few views and likes!?!?! I actually do not understand because the demand for free education like this (Video, Files, pdf notes (free book) and practice problems) is VERY high - everyone wants to learn this type of material - and yet when I supply this free education, so few people that demand it are matched with the supply. I REALLY appreciate what you say in your comments. Thank you for your kindness : )

[@kamranb1369]

Fully agree with you Mike. Everyone should hit like & sub just as a little appreciation for what you do for us. It only takes a second to hit that like button if someone stays logged in on youtube. Come on people hit that like button, show some love for this great channel :-)

[@rrrprogram8667]

Here is my analysis... Its true that Many wants to learn this kind of content ...But the REAL ISSUE is something different, let me elaborate... Say in 100 people....60 people aren't even aware of Power Query and DAX (Vlookup is the end of their Excel).... and among the left 40 ... they are split the in the following way 30 people are little aware of the PQ and DAX, they wish to learn, but they don't push themselves to learn, which demands individual to come out of their comfort zone and requires mental efforts....... they resort to doing things in the same OLD usual way.... Also, there isn't time for them to experiment with new tools..... What they really lack is the DETERMINATION.....They prefer individual class, rather than online classes (online classes hasn't picked up yet in India )... Conclusion : This will only change when certain people around with PQ and DAX skills display it's true power.... Final 10 people , who are really determined to learn whatsoever, are the ones who are DIE HARD FANS of this CHANNEL... Conclusion : When PQ and DAX gains popularity ... This channel will be "THE FAVOURITES" among the list.

[@excelisfun]

Thanks K B : )

[@excelisfun]

Thanks for the Analysis. I think you are correct. I will add one more point: most humans want a quick fix, and that is not what I teach, I teach the fix, the how to, the fun, and the whys, and the concepts behind it all... Most humans in the world don't have the determination (as you say) and the desire to know why. Even in my classes at Highline College, most just want to get through and pass and don't care about the whys, concepts and the hard work needed to gain the true knowledge. Thank you very much, RRR, for taking the time to support this channel : )

[@FRANKWHITE1996]

You are data manipulator genius. Period. 🙌

[@excelisfun]

You are becoming one too, FRANKWHITE1996 : )

[@williamarthur4801]

Well, after several attempts managed to type it all in from scratch, still haven't got my head around using the [sales] for standard deviation rather than the 'new' [Total Sales] but it's sinking in , slowly. Thankyou once again.

[@DougHExcel]

Nice group of tips...thanks Mike!

[@excelisfun]

You are welcome, Teammate Doug!

[@SyedMuzammilMahasanShahi]

Thanks Mike for such an amazing video.

[@excelisfun]

You are welcome, Most awesome Syed : )

[@pmsocho]

Great lecture about nesting PQ functions :) Thanks!

[@excelisfun]

Thanks, Teammate : ) Go Team!!!!!!

[@maharashtramaza4933]

Nice videos I am following it it's so helpful thank you so much from India

[@excelisfun]

You are welcome!

[@clay4gli]

Tremendous video, Mike. I figured I could use this feature because I have some experience in Access - it is not the same. I was getting frustrated trying to use this feature. I think you have shown me how to use it. I love the “All Rows” feature. I am trying to use the Count feature, but the field list to count always seems empty. I am not sure why. Thank you again for your in-depth knowledge and skill. ❤😊

[@excelisfun]

Glad the video helps!!!

[@mueez89]

Thanks Mike! Love you and your videos!

[@excelisfun]

Glad you like them!

[@RobertoCervantes]

i really really really thank you for all this videos and for teaching us

[@excelisfun]

You are really really welcome : )

[@zm2813]

Thank you Mike, godfather of excel

[@excelisfun]

You are weclome, Zak M!!! Thanks for the support with your comment, thumbs up and sub : )

[@orcawilly54]

Amazing video. I've watched twice for now.

[@excelisfun]

Yes!!! Two times is more fun, right?

[@mohamedchakroun4973]

No comment 20/10 Very consistent plate :-)

[@excelisfun]

Glad you are having fun with this class, Mohamed!!! Thank you for the 20 out of 10 and for the really cool "consistent plate"!!!!

[@ahmedreza3031]

i am addicted of ur videos...the way u teach r mindblowing...great sir keep it up..please if possible make vba in excel video..

[@excelisfun]

Glad you like the vdieos and they are hekpful! I keep it up if you keep supporting : )

[@niavras]

What an exemplary professor! Thank you for your dedication to support us!

[@excelisfun]

You are welcome, kostas!!!

[@shubhampawar8506]

❤️thanks a lot ...you always amaze us❤️

[@excelisfun]

You are welcome for the amazement!!

[@joaquimmendonca1350]

Excellent content as always!!! I have a question: If instead of concatenating the value or the dates? Thank you very much in advance

[@mikedbman]

Super easy to follow!

[@ceyhunozturk5115]

Thanks for everything Mike.

[@excelisfun]

You are welcome, Ceyhun!!!!

[@Muuip]

Thank you for these amazing presentations! An interesting challenge for anyone:GroupBy Minimum in a new column "min_Group" but retain all other original rows and enter NULL in column "min_Group". There must be a better way but this is how I managed it: created "unique_KEY" in original table, created second table with Minimum per Group, then merged both tables by "unique_KEY".Works, but there has to be a faster method using only one table. I guess creating a function column? Thanks!

[@vasilisa6128]

Thank you! I feel it will help me with my tasks a lot!

[@excelisfun]

You are welcome, Vasilisa: )

[@vasilisa6128]

@@excelisfun The next day I watched this tutorial and I used it in my work! It was exactly what I needed)) Thank you, Mike!

[@excelisfun]

@@vasilisa6128 I love to hear that : ) : )

[@sanukumar7122]

Thank you sir I daily watch one vedio and then practice.

[@excelisfun]

You are welcome for the daily videos, Sanu! Thank you for your support!!

[@accountingservices1727]

You are de the best, I live en Panamá city, i like this videos. Thank you very much

[@excelisfun]

So glad I can help you in Panama City!!! You are welcome very much. This is video #8. Are you watching the whole class? Or just one video. The whole class is here: kzbin.info/aero/PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1 Also, here is a 2 minute video that shows how to find just the video that you want at the excelisfun channel: kzbin.info/www/bejne/omKQYpSMnKunnpY

[@kojosephine6255]

Very organized lectures 👍

[@excelisfun]

Glad you like them : )

[@williamarthur4801]

If Milke or anyone reads this and can offer help pleas do so, I took this a stage further and grouped by total sales, the problem is then extracting 'who sold what ' for the tied position, even though I use {"who sold what " , each Text.Combine( List.Distinct( [who sold what] ), ", " )} it treats each returns a distinct for Quad and a distinct for Sunshine, which of course means duplicates when you join them together, is there a way around this?

[@a.achirou6547]

Great lecture. Thank you.

[@excelisfun]

You are welcome!!!

[@IoriYagamiKOF98]

Another amazing video

[@arvindr4258]

Thank you for wonderful video!

[@excelisfun]

You are welcome for the video, Arvind!!! Thanks for your support with your comment, thumbs up and Sub : )

[@timmytesla9655]

Thanks for another great video

[@wonjinpark7502]

Great as always. Thank you.

[@excelisfun]

You are welcome, as always Wonjin!!!! I really appreciate your support : )

[@ommm4169]

Another question, can we get the root cause of variance through PQ? (e.g. Higher due lower sales by 10 KMT.

[@abdulhaseeb8027]

I am short of words to explain how much i have enjoyed this video and how much like PQ now thanks to you. One question though regarding the ranking problem. The number goes 1 , 2, 2 , 4 instead of 1,2,2,3. Isn't it wrong or m i missing something?

[@FRANKWHITE1996]

Well explained. Thx. 👍

[@LokeshSoni-uq5dw]

Mike Whether we can use Divide (/) by row to extract only integer values instead of using Frequency function in excel?

[@MouradBENKADOUR]

Great Tutorial Thanks

[@excelisfun]

You are welcome!

[@userme2803]

Thank you for this video.

[@excelisfun]

You are welcome!

[@ExcelInstructor]

23:33 why would any1 want missing numbers like 1,2,2,4? would it be more practical to go for 1,2,2,3?