MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More

[@excelisfun]

Here is a followup video that shows how to deal with Formula.Firewall Error after we use a parameter query to deliver the folder path to the query created at 01:00:45 in this video: kzbin.info/www/bejne/omXFaayIitWUpa8

[@yearofmars]

Hi. Love the channel. It really helped me grow to understand Power Bi and I often come back here to rewatch videos and find new things whenever I do. I ran into a problem using what I learned in this video, and I think what I learned from the experience is quite instructive about how power bi query and transform functions. supplychaindatascientistcom.wordpress.com/2020/12/10/why-is-my-power-bi-query-so-slow-a-query-is-not-a-table/

[@ExcelInstructor]

1 question? where do u have a pound sign? i see hashtags, or u mean hashtags? or Am I missing something?

[@excelisfun]

@@ExcelInstructor It is hashtag : )

[@ElTigreFIME]

Mike, you deserve heaven for all the help provided to this community of enthusiast learners….God bless you!

[@excelisfun]

It is a sort of heaven here at KZbin because I get to post my fun videos to try and make the world a better place, free of charge : ) Actually, I do charge a thumbs up for each video that people learn from lol

[@ElTigreFIME]

@@excelisfun You got it!

[@arifzainal9317]

When I hear "Wow, that's a lot of fun..", I immediately knew I absolutely need to re-watch this again :D. Packed with real gems!! Thanks very much Professor Mike!

[@geeee8933]

The end of this video was full of bangers! always have to watch to the end...

[@excelisfun]

Glad the videos and bangers at the end help : )

[@maci6990]

Working a couple of years with Power BI now. Never quite liked the M side of it. I managed to do the basics without actually understanding M-code. This video changed that, BIG TIME! Thanks a lot! Now heading back to my EMMM CODE (lol!)

[@excelisfun]

Glad this helps, Ma Ci!!!!

[@chhanditachowdhury5565]

I have never seen somebody put in so much effort to teach stuffs. Wishing you many more subscribers.

[@excelisfun]

I hope it works for you and you can learn useful things : )

[@othmanelebbache3026]

i' so grateful for what you do Mike, i really learned a lot of things, thank you very much

[@excelisfun]

You are welcome so much!!!!

[@excelisfun]

There are practice problems (homework) so you can have fun trying your new M Code skills in the homework Excel file link below the video : )

[@maxnguyen828]

Thanks Mike. Last problem is a real challenge.

[@imatzav]

I'm speechless once again! Yesterday it took me several hours looking here and there to figure out how to do exactly the same thing as your example starting at 57:50. I wish I had watched this video earlier. You are the best Mike! I've learned so much from your videos all these years.

[@excelisfun]

I am glad to help you, imatzav!!!!

[@greghorsman4102]

Hi Mike, I can see from the date and time stamp on most of the comments that I am late to the game. Still, I am extremely satisfied that I found your channel. Your presentation and teaching skills are definitely top shelf and I can say that I've been working with PQ for the last 2 1/2 years. I look back on my early work and just shake my head and wonder how any of it worked. Thanks for making great informative videos.

[@excelisfun]

You are welcome, Greg!!!

[@ammylove123]

thank you so much for creating these incredible teaching videos. They are really helpful to my work. :)

[@excelisfun]

Glad they are helpful!!!

[@NjaanAdima]

Your presentation is more powerful than the power query! Feeding energy to the brain. I started loving the data analysis after watching a couple of your KZbin. Thank you very much, Mike! Keep Safe.

[@excelisfun]

You are welcome for the power and fun with Microsoft Power Tools for Data Analysis, Samuel!!! This #9 is a LOT of M Code fun : )

[@mazarata73]

Wow, just speachless on the information density packed in this video and on how well founded it is. That's really an incredibly steep learning curve. For me as a trainer I get inspired by your didactical path, Mike. Am very much looking forward to your next videos. Thanks so much.

[@excelisfun]

You are so welcome, Fellow Trainer and Teammate!!! This video is really packed - it is the most epic video (most densely packed with content in one video) that I have even made. Thank you for your support with comments and all else : ) : )

[@ljubicar1987]

WOW!!! This video is worth watching dozens of times! Can't find the words to complement your classes enough. Thank you for unselfishly sharing your knowledge!

[@excelisfun]

Yep, free and the most comprehensive M Code content on the net : )

[@larrycroce4874]

Mike, I've watched your entire series on Array Formulas and am working my way through these Power Pivot videos. Your videos are by far the best series I've ever watched. The things I've learned have been a great benefit in my overall Excel skills as well as having real work applications. I have multiple data files located across multiple sites and I've been able to link them all into a very useful dashboard thanks to you. Keep up the great work, you're providing a terrific service for us!

[@excelisfun]

You are welcome, Larry!!!! I post so I can help people become efficient in a fun way! Please by commenting and Thumbs Up on each video you watch : ) The service goes both ways!!

[@tosaksettharungson]

After many self trials and errors expecting M to be kind of similar to VBA and Excel formula, this episode came to the rescue and gave me hope again. THANK YOU!

[@excelisfun]

Yes, M Code is noting like Worksheet Formulas or VBA. Although it is more like SQL, even here, M Code is its own unique and amazing language : ) Thanks for your support on these videos that you learn from with your comments, thumbs up, and of course your Sub. It means a lot to me and helps grow the channel so that more people can find this free education : )

[@harifitfunk1112]

This is fabulous given the simple way you put forth every minute detail in a large video. The articulation is really awesome. I watched for 3 times to get nitty gritty of the CLASSIC CLASS

[@excelisfun]

You are so welcome for this Classic Class!!!! It does take a while to learn a completely new language like M Code. But this videos has the foundation. Tell all your friends and colleagues so we can get more of the world using M Code and making data magic happen : )

[@ziggle314]

First-rate exposition. Best presentation I have seen on the data structures in PQ and the M-syntax needed to access the data within them. Thanks, Mike!

[@excelisfun]

You are welcome, ziggle314!!!! Glad it helpfula dn thanks for your support with your comment, Thumbs Up and Sub : )

[@christophertauss3640]

This is a mind-boggling good intro to M Code. I admire your energy and thoroughness in going over the material. After this is will start looking at your other videos on this topic as well as Power Pivot and Power BI. Awesome stuff. 100 stars for you and many thanks.

[@excelisfun]

Thanks for the 199 stars, Chrsitopher!!! Yes, for 12 years, I have been here at KZbin providing free Excel Education for the world! To get the most out of all that I have posted, watch my 2 minute into video that shows how things work : kzbin.info/www/bejne/omKQYpSMnKunnpY Let me know if you need help finding something.

[@excelisfun]

Thanks for your support on each video that you learn from with a comment and thumbs up, and of course your Sub : )

[@malchicken]

One of the most informative videos I have watched in years of watching KZbin videos. Very well done, thank you.

[@excelisfun]

Glad you finally found my channel. There are many, many other Power Query and M Code and DAX and Dynamic Array topics that you will not find in other places. I hope you Sub and hang around because we have a lot of fun at the excelisfun channel learning efficient and fun tricks. The MSPTDA and E-DAB playlists are quite comprehensive if you are doing Data Analysis with Excel Power Tools. Thanks for your support on each video, Hendrick, with your comments and thumbs ups : )

[@panh4190]

It took me at least 4 times to go back this videos to nearly understand the whole amazing thing! Gonna spend the 5th time :) Thank you sir!

[@excelisfun]

That is how we humans get good at things: repeat, repeat, repeat : ) So glad that this helps. BTW, I just posted a re-do of this video (since this is 4 yeasr old), and it should be even better than this one: kzbin.info/www/bejne/aYvOeqqBd7uejKc

[@kamranb1369]

This was the best video I have ever seen on M code. Thanks a lot, Mike. I am gonna watch it a couple of times, there is a lot of info. Have to master everything because this video covers all the foundations.

[@excelisfun]

Glad it helps, K B. For me, this video took longer to prepare than any other video I have ever made. There is a lot of info and I hope you will enjoy studying it and then find power in M Code Power Query : ) Thanks for your support, K B, and tell all your friends and colleagues there is epic M Code fun here at excelisfun : )

[@masterof]

Thank you Mike - this one is amazing! I learn so much of PQ in this video, I wish I have watched it earlier! Many thanks for your great efforts to make these videos, many things in Power Query starts to make sense to me after watching this one. I found myself getting lazier nowadays, instead of writing those great formulas (especially ones involves array formulas and many complex and long formulas which no one else can read) I am now using Power Query to solve. I can make a copy of the file, delete all the power queries to deliver just the results, and no one knows how I make the magic happen! Now I use the time saved to watch even more ExcelIsFun videos!

[@excelisfun]

I love that logic: Use Power Query a lot to save time, then watch more videos : ) ... I am the same as you in that I use far fewer Cray Old School Array Formulas now becasue of; 1) Power Query and 2) Office 365 Dynamic Array Formulas. Thanks for helping me with those comments and thumbs ups on each video, rf05mjy : )

[@shoeshines2121]

What an epic video! This is by far the best video on the Internet explaining M Code that I have seen. Thank you for this amazingly comprehensive guide to writing and reading M Code. I will most definitely refer back to this video in the future.

[@anisdadani8980]

This series is price-less. I have subscribed to at least 20 paid courses on Udemy. However none can beat you in transferring knowledge. May Allah ( SWT) bless you with best

[@excelisfun]

It is true. There are so many bad "for money" classes... When it is all for free at the excelisfun channel at KZbin : ) But I do charge you a comment and thumbs up on each video ; )

[@damienmearns9842]

You show one thing, and I'm asking "yeh but what if..." and the next sentence you answer it - time and time again - top pro ! best video on M I've seen

[@excelisfun]

Good teaching , which is good story telling is all about incorporating potential question into the story line : ) Thanks for watching and support excelisfun!!!!

[@binhthai078]

I wish I could give you more than just one like. Thank you for your lecture.

[@excelisfun]

Liking each video that you watch one time is good for me : ) I love it!

[@soniccheese01]

Fantastic intro to M code. I really appreciate the hard work you obviously put in to make our lives easier where learning is concerned. Many thanks Mike

[@excelisfun]

You are welcome for the M Fun, Kevin!!!! And you are right, with the script writing, filming, video production, Excel file creation, pdf notes and making homework - it is a HUGE amount of work. It is my way to try and make the world a better place : ) Thank you for your support with your comments, Thumbs Up and telling all your friends : )

[@denisdwyer3103]

I'm working my way through your videos Mike. You deserve congradulations on each, but I have only been leaving the occasional comment. This coverage on M code is terrific. You have made it much less daunting.

[@excelisfun]

Glad it all helps you, Denis!!! Comments and thumbs ups really do help me to : )

[@johnborg6005]

GOLD !!!!! its fun practising and watching magic happening in front of you. Thanks Mike.

[@excelisfun]

Yes, this video is M Code Gold! Thanks for stopping by in the comments, John Borg : )

[@laviedandre]

Hi Mike, so excited that you're now teaching these more advanced concepts in M and DAX. Have always loved your approach and know that many (many!) will benefit from it. Thanks for all you do!

[@excelisfun]

You are welcome, Andre!!!! Thanks for your kind words. I hope you are right and I hope that may will benefit from this comprehensive M Code video : ) Thank you for the support, Andre with comments, Thumbs Up and tell all your friends : )

[@__HumanBeing]

You should charge people for this videos.. they are gold!

[@__HumanBeing]

This is university. This is not supposed to be out there for free. Thank you so much!

[@excelisfun]

For 14 years I have provided free Excel and Data Analysis education for free at KZbin. It helps the world!

[@excelisfun]

@@__HumanBeing OK ; ) The university class will cost you a thumbs up for each video!!

[@knikl]

I am clapping my hands (can you hear me?). Recording the video, adding the pdf notes, the excel files, etc... and on top of that replying to all the comments!! You are a legend.

[@excelisfun]

Yes, knikl, I take my duty to try and make the world a better place seriously : ) That is why I appreciate when viewers like you show regular support, like clapping in the comments ; ) : ) : ) : ) : )

[@NguyenNguyen-nr8bx]

you are an exceptional instructor Mike, really easy to follow.

[@excelisfun]

Thanks for the kind words, Nguyen! Thanks for your support with your comment, Thumbs Up and Sub : )

[@mueez89]

This is one amazing all in one M code video. Microsoft would do so much better if they linked it to official documentation. Thank you so much Sir Mike Girvin!!

[@excelisfun]

Glad you like it! You are welcome, Mueez!!!!

[@nattawut_chatwiriyacharoen]

This video is awesome. It's the best M Code explanation I have seen. Thanks a lot, Mike.

[@excelisfun]

You are welcome, Nattawut!!!! This single video took me longer to prepare and make than any other video that I have ever made. So I am glad that it looks good to you : ) Did you post it in your blog? (Also, did you see the video I posted two days ago? It is a two hour video about Power Pivot and DAX: kzbin.info/www/bejne/iJPOk6VubsioftE It is similar to this one in that it is very detailed and thorough...)

[@nattawut_chatwiriyacharoen]

@@excelisfun This video is around 1 hour but I spent around 5 hours to watch. There are lots of tips, tricks and details. I had to pause the video every 3 minutes, follow your steps, do some experiments, take a short note. That's a lot of fun ^__^ Actually, I found a problem regarding to Firewall Error, however the MSPTDA 9.5 gave me a clear answer. I won't miss the MSPTDA15 (DAX Formula) for sure. Just see the pdf file and it can answer tons of questions. Maybe I have to spend a whole day to watch this video, but I can imagine that you had spent a week (maybe more) to create this precious video. Thanks a lot Mike. You are a great teacher.

[@excelisfun]

@@nattawut_chatwiriyacharoen , Yes, all of us humans who want to learn watch it the way you do. Me too. I watch videos to learn and I stop the video every few minutes and try the fun tricks and then start the video again. And yes, the pdf notes have a lot of detail : ) And yes, the DAX video might take all "fun" day!!!! By The Way, Nattawut, if I told you how much time it takes to create all the Excel Files, Data Sources, pdf notes, research on some topics, video filming, filming editing, pre-upload tagging, creating table of contents, posting and pre-upload work... you would not believe it. This video took over 200 hours and the DAX video #15 took over 120 hours... I hope you can do what you did before and post announcements and links of these videos at your blog : )

[@nattawut_chatwiriyacharoen]

@@excelisfun You're amazing! I can imagine how much efforts you have put to the 200 hours. There is no doubt why the quality is a very high standard. Many thanks. I shared this video to my facebook fanpage and blog yesterday. A result is good, lots of likes and shares This is what I posted to my facebook fanpage web.facebook.com/reportingengineer/posts/2223014307941675 This is what I posted to my blog reportingengineer.com/2018/11/23/%E0%B8%84%E0%B8%A5%E0%B8%B4%E0%B8%9B%E0%B8%AA%E0%B8%AD%E0%B8%99-m-code-%E0%B8%97%E0%B8%B5%E0%B9%88%E0%B8%94%E0%B8%B5%E0%B8%97%E0%B8%B5%E0%B9%88%E0%B8%AA%E0%B8%B8%E0%B8%94%E0%B9%83%E0%B8%99%E0%B9%82/#more-22473

[@excelisfun]

@@nattawut_chatwiriyacharoen , Thank you very much for sharing this video : ) : ) : ) : )

[@AlessandroBAM]

I have never been able to learn so much about m code in just one hour!

[@excelisfun]

I am glad that this MSPTDA class can help you, Alessandro!!!

[@sandip_bettereveryday]

Simply awesome. I will need to watch it again and again and again.... to get a solid understanding of all the useful topics taught in this lesson, so that I can make use of those. Thanks a ton!

[@excelisfun]

You are welcome a ton!!! Yes, this is one of the most epic videos I have ever made - it has so much info. Thanks for your support, Sandip : )

[@DIGITAL_COOKING]

can you believe I watched this video three times, awesome work mike ...awesome

[@joannapaziewska261]

this is just amazing. finally step by step explanations. I am really using tons of your videos for my work

[@excelisfun]

That is awesome that they help so much at work, Joanna!!!! That is why I publish all my free classes here at KZbin for last 13 years: making working life easier : )

[@Mekinhumbel]

@@excelisfun You've been saving my bacon at work for years now, and this one is no exception! Literally everything I've been confused about with M cleared up in a little over an hour--thanks again, Mike!

[@excelisfun]

@@Mekinhumbel Glad to help save bacon any day, sadfj!!!!

[@Vandalfoe]

OMG this stuff is so good! I would pay for this kind of content. In fact it's better than anything I HAVE paid for! I wish I could subscribe more than once!

[@excelisfun]

Glad you like it, Eric! It has been my goal for 13 years to provide free Excel education here at KZbin : )

[@spicyinstantnoodles9468]

all i can say is the video is LIT. dude is TRUE expert and excellent teacher

[@joanneosborne2428]

This is Excellent! I was looking for this simple explanation of M and I finally found your site. You explain things so well. Thank you for not overcomplicating it. 🙌🤩 I am enjoying all of your training videos

[@excelisfun]

You are so welcome! Glad you like the stories that I tell M and other topics : )

[@xiaolizhou4575]

Gosh - This video is amazing!! - The best video I"ve ever seen about this topic and it's much better than most of charged courses.... Will follow up and looking forward for more high-quality videos! Thank you for making this!!

[@excelisfun]

You are welcome! Yes, I try to make great videos and provide the resources for free here at the excelisfun channel at KZbin! Please help support, Xiaoli with a Sub, click that Thumbs Up on each video and comment when you are inspired : )

[@tpmanzano]

Great video, clear and concise. A new fan of ExcelIsFun!

[@excelisfun]

Thanks for your support on each video and a Sub, Thomas! Glad the resources help. Did you check out the pdf notes, Workbooks and practice problems?

[@DIGITAL_COOKING]

awesome mike !!!!! very very awesome you are MVP of the MVPs exist in the world no one can do videos like you and I challenge who say the opposite I' m so glad to know your channel mike because of improvements in my work first, and I'm looking for passing exam so I find the best staff to prepare for the exam ...... thanks

[@excelisfun]

You are welcome, DIGITAL COOKING!!! Thank you for your kind words! This is definitely an epic video with a LOT of information, so happy studying : )

[@israfilgazi8071]

Very Agreed

[@umangdbz]

Thanks

[@excelisfun]

You are welcome, umangdbz!!!!! Thank you for your generous donation : ) It really helps me to keep making content. Go Team!!!!!

[@nazimscr]

Wow amazing video very helpful, thanks Mike I have been following you for more than 12 years . Your videos have really helped me to thrive in my job. Thanks Nazim

[@excelisfun]

You are welcome, Nazim!!!!

[@mohamedchakroun4973]

Power query functions make my head spinnnnnn :-) thanks mikeeee girvin you will remain the best teacher forever

[@excelisfun]

Thanks for the kind words, Mohamed!!!! And, the good news that if it makes your head spin, no worries because the video will be here forever so you can come back and re-watch and leran : )

[@MalinaC]

It's getting more and more advanced! Thank you Mike for this awesome video!

[@excelisfun]

You are welcome, Malina!!! Advanced is good, I hope : )

[@MalinaC]

@@excelisfun it definately is!!! Hope for more 🙂

[@excelisfun]

O Yes!!!! The next video will be even more epic then this video because we will use a lot of manually created M Code and a Custom Function to do a complex transformation : )

[@coccinelleladybird6364]

Thank you Mike for your generosity for providing these amazing trainings.

[@excelisfun]

You are welcome for the amazing training, coccinelle ladybird!!!!

[@elactecnology]

This is just an interesting course you have recorded. I am gonna recomend it for all of my friends. So wonderful class. Thank you Mike

[@excelisfun]

Yes, this free class can give people real power : ) Thanks for spreading the word!

[@amerfarooq1142]

really a great contribution by Mike to improve the life of excel users

[@excelisfun]

You are welcome, Amer!!!!

[@petermyran4986]

This one is packed with gold!! I have a much better grasp and comfort level with M code as a result. I appreciate the stretch homework provides. I did HW #5 slightly differently (getting the same result). It allowed me to mine #shared to solve. 'There is always more than one to do it' LW + Perl :) Thanks again Mike !!!!!!!

[@excelisfun]

You are welcome! I am so glad that homework is useful - practice makes perfect. Yes, there are multiple ways to do it. Thank for your consistent support, Peter : )

[@shubhamgurav1966]

Amazing tutorial MG!! It's one of the best tutorials on M I have seen so far. Great job and keep posting videos on new techniques to use M. Thanks :)

[@excelisfun]

Okay! Glad you like it! I have many videos about Power Query and M Code. Here is a playlist for Power Query: kzbin.info/aero/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK (158 videos - every video I have made about all of Power Query) Here is a playlist of just M Code Custom Functions: kzbin.info/aero/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca (13 videos - all of which are in previous playlist)

[@mohamedkaram8899]

Amazing, thanks a lot Mike.

[@excelisfun]

You are welcome!!!

[@mattschoular8844]

Excellent! So much good content in this video I think I need to upgrade the memory in my brain to 1TB. Thanks Mike. ..

[@excelisfun]

When you figure out how to upgrade brain to 1 TB, please let me know : ) Thanks for the support, Matt!!!

[@JSUG4219]

WOW! Well worth the wait! Thanks, Mike for kicking it up a notch!

[@excelisfun]

Yes, kicking it up a few notches for more fun : ) Thanks for your support, Jack!!!

[@hi2832]

Now the difficult/challenging part has started but with practice and watching at least twice we can understand. I would suggest don't move further till we have good grip so far from MSPTDA FROM 01 to 09. Excellent job.

[@excelisfun]

You are right: 1) There is a lot of material, 2) And in order to learn it you must practice : )

[@Jhnn_007]

Ty teacher, you give me hope

[@excelisfun]

I am glad to give you hope : ) : ) : )

[@AtulSharma-gf5vs]

Simply Marvelous!!!

[@excelisfun]

Glad you like it!!!

[@jleonard5106]

All I can say is wow. Mcode can do so much more than I thought.

[@excelisfun]

This is only an introduction and basics. For Data clean/manipulate/transform there is nothing else in Excel that can even come close. It adds a whole new level of infinity to our beloved Excel : )

[@excelisfun]

Glad you like this video, jleonard5106! Thanks for your support with your comment, thumbs up and sub : )

[@ismailismaili0071]

dear Mr. Mike I have been waiting for your video for a long time once you posted it i was already in holiday vacation so sorry i couldn't watch it at that time but i'm watching it now thank you I always appreciate your videos because i'm learning a lot from them.

[@excelisfun]

You are welcome! I am glad that you learn a lot : ) I hope your vacation was good! Where did you go on vacation?

[@ismailismaili0071]

I went to China it was great thank you.

[@barttitulaerexcelbart9400]

This whole course is excellent. But this video gives you a deep understanding behind the scenes. I will definitively go back to this video once in a while if I need to alter the automatic code. Actually it is more logical than at first glance. thank you.

[@excelisfun]

You are welcome, Bart!!! Yes, this video has a LOT of information - and may have to be watched a few times! Thanks for your support : )

[@MrSemyonoff]

Thanks, Mike! Watched this video few years ago and now after I have mastered M watched it again to align my knowledge with that you said in that video. Very good explanation of M. It would be great if you could make a video regarding using Table.AddKey function and if there is any performance benefit for some kind of functions, like Group By or Merge. Many thanks for your great job!

[@reng7777]

Wow what a level of expertise you have my friend!!!

[@excelisfun]

Now you get to have it too!!!!!

[@ahmedal-dossary4386]

You are a king..!!!! What a comprehensive video

[@excelisfun]

Yes, that is an epic video!!! Thank you for your support, Ahmed!!!!

[@shubhampawar8506]

Great vedio as usual ❤️..You always make complex things easy so that anybody could understand it ...many thanks to you 😊🙏

[@excelisfun]

This is one of the most important videos in the whole class. All about M Code. M Code is not easy to learn, so you can come back and use this video anytime : )

[@shubhampawar8506]

@@excelisfun yes ..thanks a lot for such great vedio ....yeah I'm going to go through it again❤️

[@OzduSoleilDATA]

WOW! You're going all in!

[@excelisfun]

All in is More Fun : ) Thanks for your support, Oz!!!!

[@RusAlin]

Such an amazing lesson! I just started to learn the M-code and your explanations are excellent!!

[@excelisfun]

Glad to help : ) : )

[@sasavienne]

Microsoft must be so grateful to you Mike. 👍 🌟 🌟 Thanks a lot. 👍 🌟 🌟

[@excelisfun]

I do not know how grateful they are. But I hope that they will see that I try to help teach about their products in a positive way, all for free : )

[@taitu7538]

This is the best Power Query's tutorial. Thanks a lot.

[@mammadzada23]

SOOOOOO Thanks!!! You are the GOD of EXCEL!!!

[@excelisfun]

You are sooooooo welcome, Ali!!! Please help me to continue with your comments and Thumbs up on each vid : ) And a Sub too : ) : )

[@bli240]

Another great video! Thanks so much for this. I definitely learnt a lot watching this. One thing to note about lookup (projection & selection) that I noticed while working on a project is that it's performance isn't ideal over a large dataset. I think most Excel users would be tempted to use lookup to mimic index & match in vanilla Excel. While it could get you the results you'd need, Merging queries (joins) would perform better.

[@BillSzysz1]

Thanks Mike for this comprehensive guide!!! :-))

[@excelisfun]

You are welcome, O Power Query Poet and Artist : ) I think I learn most of this from you : ) : )

[@tejak1886]

I do not have any words to say...Awesome..Thanks Mike.

[@excelisfun]

Yes you do have the words and thank you for them !!!! This video is Epic M Code stuff! Thanks for your support, Teja K, on each vid with your comments, thumbs Up and of course your Sub : )

[@johnwatson8203]

Great to see your are still rocking it!

[@excelisfun]

M Code makes it easy to rock : )

[@entertainmentgalaxy971]

wow. complete, important and very useful intro about M Code. Thanks for sharing

[@excelisfun]

Glad it was good for you, Haider! Thank you for your consistent support : )

[@ExceliAdam]

As usual fantastic job and thorough discussion of the topic 👍

[@excelisfun]

Thanks, Teammate Excel.i Adam!!!!!

[@timwhite8952]

Amazing video. Thanks for posting. I will have to watch it again as there is lots of great info to digest.

[@excelisfun]

Yes, this is one you will have to watch and take notes, then do it again. I should have broken the video up intro multiple videos, but I sort of wanted to have all this M Code Basics and beyond in one viodeo, so it could be a one stop shopping when you needed a reference video...

[@linelson]

That is beautiful! Best video in this playlist so far Mestre Yoda!!!

[@excelisfun]

Thanks for those kind words, linelson!!! Thanks for your support : ) And... if you think it is the best, then you might be a true Power Query M Code Master : )

[@qiancasper]

Thanks for making this great content. I had deeper understand now after half year period of using PowerQuery & Dax. A couple days ago Im a bit confused abt the custom function and now I'm more clear.

[@excelisfun]

Here are other videos about Custom Functions: kzbin.info/aero/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca I

[@qiancasper]

@@excelisfun just watched once and I think that’s exactly what I want really appreciated for sharing

[@sherryizzie5309]

Another amazing video! Many thanks for sharing your knowledge with us for free, Mike!

[@excelisfun]

You are welcome, sherry! Your comments and Thumbs Ups and good pay for the "free" resource : )

[@michajlo86]

Brilliant as always. BTW there's a useful trick in Advance Editor to quickly comment out code. Highlight the code --> Ctrl+/

[@FabioGambaro]

Wow, this was packed with content! I had to go back a few times to ensure I understood correctly - and I believe I'll need to see it again...

[@excelisfun]

Great - I am glad that packed with content for you, Fabio! Thank you for your support : )

[@zaafirc369]

I love this! Thanks for providing such quality content for free.

[@excelisfun]

You are welcome, Zaafir! Thank you for your comment, thumbs up and Sub : )

[@zaharterentev2091]

Very thank you! Its the best video lesson I have ever saw. I wish you all goods of our world)) for that)

[@excelisfun]

Glad this video helps, Zahar!!! Thanks for your support with your comment, thumbs ups and of course your sub : )

[@LeePartington51]

Superb content and delivery Mike (as always) 👏👏

[@rrrprogram8667]

EPICCC video by EPIC TEACHER.... Cant digest it all in one go.. Thanks alot Mike...

[@excelisfun]

Epic is right - so much in one video - lucky there is a replay and rewind button!!!! Thanks for the support, RRR!!!

[@rrrprogram8667]

ExcelIsFun ya partially lucky that there is a replay button for the video... But if there was a rewind button for life.. I would rewind 10 years back to subs and follow this channel

[@ExactProBi]

an amazing video! thank you Mike, more power to ExcelisFun and Power Query

[@excelisfun]

Glad the video was amazing for you! Thank you for the support with your comment, Thumbs Up and Sub : ) I just Subbed to your channel too : )

[@ExactProBi]

Thanks, Mike, it's my honor that you have subbed to my Channel, what books you would recommend for Power Query apart from Ken/Miguel's books to gain advanced knowledge of M Code? I am already enrolled into Power Query Academy course and waiting for Ken/Miguel's second edition book M for data monkey... what books or courses are best for learning Power Pivot/DAX/Power BI? Btw I have been your subscriber since many years :)

[@excelisfun]

The books I liked are: Definitive DAX by Russo and Ferrari and Chris Webbs's Power Query book.

[@khaledseghari1189]

Another great video. Thanks Mike you are excellent teacher.

[@excelisfun]

You are welcome for the M Code Fun!!!!!

[@rfeyman3682]

Good overview and examples of M code. I usually don't use the remove duplicates feature, because I have run into quite a few issues with Excel deleting information I wanted to keep and keeping information I wanted to delete. Kind of wish there was a way to just flag the duplicates like the old school array formulas and then you can start researching why you have duplicates.

[@jacksonhz]

Great video!! Congratulations for the excellent work, the methodology and communication of msptda!

[@msantosh1220]

Nice intro to Mcode, had difficulty on understand few of the points but I hope they will be clear as I move along in this course... Thankx Mike

[@excelisfun]

Not much more M code in videos left, but it will pop up a few times... Keep the pdf notes and a bookmark on this video when you need to be reminded : ) Thanks for the support for the excelisfun channel with your comments, Thumbs Ups and your Sub : )

[@eladiobardelli3001]

Quede awesome , gran video vamos por esos Power M , gracias y mas saludos desde Chile from Chile.

[@excelisfun]

¡De nada! Gracias por su apoyo, con su comentario, Thumbs Up y Sub!

[@valdickens9648]

Simply the best! Thank you, Mike!

[@excelisfun]

You aer welcome, Val!!! Thanks for the support : ) !!!

[@jitendratrivedi7889]

Epic Video Sir. Best Tutorial. Request you to please create separate playlist for M code videos.

[@vida1719]

Extremely good explanation. Just amazing.

[@excelisfun]

Yes! Glad it is amazing for you, Vida!!! Practice up, because next video will will use many of the tricks in this video and many others from earlier Power Query Video to do an epic Power Query transformation for a single Data Model part!! Thanks for the support : )

[@Victor-ol1lo]

M-Power !!! Amazing video !! Thanks Mike...

[@excelisfun]

You are welcome! What was your favorite trick in this video, or favorite new concept?

[@Victor-ol1lo]

Drill Down / Primary Key - was a surprise ... :-)

[@excelisfun]

Cool! : )

[@kebincui]

Thanks Mike for sharing. The tutorial is so amazing!👍🏻👍🏻👍🏻👍🏻👍🏻

[@excelisfun]

Glad it is amazing for you!!!!