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

Рет қаралды 177,760

6 жыл бұрын

Download Excel START Files:
Excel Start: people.highline.edu/mgirvin/A...
Zipped Folder: 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 - these are problems for you to practice your new M Code skills:
Download Excel File with Homework: people.highline.edu/mgirvin/A...
Example of Finished Homework: people.highline.edu/mgirvin/A...
In this Video learn the basics of M Code, the computer language behind queries in Power Query.
Topics:
1. (00:15) Introduction
2. (03:46) Edit M Code: Applied Steps
3. (03:46) Edit M Code: Formula Bar
4. (03:46) Edit M Code: Advanced Editor
5. (09:50) Expressions
6. (09:50) let expressions
7. (17:34) Comments in M Code
8. (21:11) Values: Primitive, List, Record, Table, Function
9. (30:45) Lookup or Projection and Selection. Learn about Row Index Lookup and Key Match lookup
10. (42:50) Primary Keys, including Table.AddKey function.
11. (50:20) Custom Functions
12. (57:44) Parameter Queries
13. (01:02:27) Underscore Character _
14. (01:06:17) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Пікірлер: 444

@excelisfun 5 жыл бұрын

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: kzfaq.info/get/bejne/opqSa9yDutbFn4E.html

@yearofmars 3 жыл бұрын

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 3 жыл бұрын

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

@excelisfun 3 жыл бұрын

@@ExcelInstructor It is hashtag : )

@shoeshines2121 4 жыл бұрын

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.

@arifzainal9317 3 жыл бұрын

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!

@ljubicar1987 4 жыл бұрын

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 4 жыл бұрын

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

@modernaone 2 жыл бұрын

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

@excelisfun 2 жыл бұрын

It is a sort of heaven here at KZfaq 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

@modernaone 2 жыл бұрын

@@excelisfun You got it!

@ziggle314 6 жыл бұрын

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 6 жыл бұрын

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

@larrycroce4874 5 жыл бұрын

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 5 жыл бұрын

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!!

@mazarata73 5 жыл бұрын

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 5 жыл бұрын

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 : ) : )

@laviedandre 6 жыл бұрын

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 6 жыл бұрын

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 : )

@excelisfun 6 жыл бұрын

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 4 жыл бұрын

Thanks Mike. Last problem is a real challenge.

@masterof 5 жыл бұрын

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 5 жыл бұрын

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 : )

@denisdwyer3103 4 жыл бұрын

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 4 жыл бұрын

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

@NjaanAdima 3 жыл бұрын

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 KZfaq. Thank you very much, Mike! Keep Safe.

@excelisfun 3 жыл бұрын

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 : )

@malchicken 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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 : )

@chhanditachowdhury5565 2 жыл бұрын

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

@excelisfun 2 жыл бұрын

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

@soniccheese01 5 жыл бұрын

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 5 жыл бұрын

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 : )

@imatzav 2 жыл бұрын

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 2 жыл бұрын

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

@christophertauss3640 4 жыл бұрын

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 4 жыл бұрын

Thanks for the 199 stars, Chrsitopher!!! Yes, for 12 years, I have been here at KZfaq 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 : kzfaq.info/get/bejne/opddZMSHzKzYmGg.html Let me know if you need help finding something.

@excelisfun 4 жыл бұрын

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

@DIGITAL_COOKING 5 жыл бұрын

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

@sandip_bettereveryday 6 жыл бұрын

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 6 жыл бұрын

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 : )

@harifitfunk1112 4 жыл бұрын

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 4 жыл бұрын

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 : )

@maci6990 2 жыл бұрын

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 2 жыл бұрын

Glad this helps, Ma Ci!!!!

@greghorsman4102 2 жыл бұрын

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 2 жыл бұрын

You are welcome, Greg!!!

@johnborg6005 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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

@tosaksettharungson 4 жыл бұрын

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 4 жыл бұрын

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 : )

@kamranb1369 6 жыл бұрын

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 6 жыл бұрын

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 : )

@spicyinstantnoodles9468 5 жыл бұрын

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

@shubhamgurav1966 4 жыл бұрын

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 4 жыл бұрын

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

@bli240 5 жыл бұрын

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.

@damienmearns9842 5 жыл бұрын

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 5 жыл бұрын

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

@joanneosborne2428 2 жыл бұрын

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 2 жыл бұрын

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

@petermyran4986 6 жыл бұрын

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 6 жыл бұрын

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 : )

@MrSemyonoff 3 жыл бұрын

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!

@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: kzfaq.info/get/bejne/acCbfNp8p7zPhnk.html

@mohamedchakroun4973 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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 : )

@NguyenNguyen-nr8bx 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@coccinelleladybird6364 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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

@knikl 4 жыл бұрын

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 4 жыл бұрын

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 ; ) : ) : ) : ) : )

@RusAlin 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

Glad to help : ) : )

@mueez89 2 жыл бұрын

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 2 жыл бұрын

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

@Vandalfoe 3 жыл бұрын

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 3 жыл бұрын

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

@nazimscr 4 жыл бұрын

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 4 жыл бұрын

You are welcome, Nazim!!!!

@anisdadani8980 4 жыл бұрын

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 4 жыл бұрын

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

@xiaolizhou4575 5 жыл бұрын

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 5 жыл бұрын

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

@AlessandroBAM 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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

@barttitulaerexcelbart9400 6 жыл бұрын

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 6 жыл бұрын

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 : )

@elactecnology 3 жыл бұрын

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 3 жыл бұрын

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

@jacksonhz 5 жыл бұрын

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

@qiancasper 2 жыл бұрын

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 2 жыл бұрын

Here are other videos about Custom Functions: kzfaq.info/sun/PLrRPvpgDmw0kuIuvn2rCQI14AthSZ43ca I

@qiancasper 2 жыл бұрын

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

@johnwatson8203 3 жыл бұрын

Great to see your are still rocking it!

@excelisfun 3 жыл бұрын

M Code makes it easy to rock : )

@mattschoular8844 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@amerfarooq1142 3 жыл бұрын

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

@excelisfun 3 жыл бұрын

You are welcome, Amer!!!!

@taitu7538 4 жыл бұрын

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

@rfeyman3682 4 жыл бұрын

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.

@DIGITAL_COOKING 6 жыл бұрын

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 6 жыл бұрын

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 5 жыл бұрын

Very Agreed

@sherryizzie5309 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@joannapaziewska261 3 жыл бұрын

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

@excelisfun 3 жыл бұрын

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

@Mekinhumbel 2 жыл бұрын

@@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 2 жыл бұрын

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

@LeePartington51 Жыл бұрын

Superb content and delivery Mike (as always) 👏👏

@MalinaC 6 жыл бұрын

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

@excelisfun 6 жыл бұрын

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

@MalinaC 6 жыл бұрын

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

@excelisfun 6 жыл бұрын

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 : )

@entertainmentgalaxy971 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@hi2832 4 жыл бұрын

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 4 жыл бұрын

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

@geeee8933 8 ай бұрын

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

@excelisfun 8 ай бұрын

Glad the videos and bangers at the end help : )

@nattawut_chatwiriyacharoen 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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: kzfaq.info/get/bejne/iMibldVpnsnZeKM.html It is similar to this one in that it is very detailed and thorough...)

@nattawut_chatwiriyacharoen 5 жыл бұрын

@@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 5 жыл бұрын

@@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 5 жыл бұрын

@@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 5 жыл бұрын

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

@linelson 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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 : )

@tpmanzano 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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?

@sasavienne 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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 : )

@othmanelebbache3026 11 ай бұрын

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

@excelisfun 11 ай бұрын

You are welcome so much!!!!

@BillSzysz1 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@timwhite8952 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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...

@valdickens9648 5 жыл бұрын

Simply the best! Thank you, Mike!

@excelisfun 5 жыл бұрын

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

@reng7777 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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

@msantosh1220 5 жыл бұрын

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 5 жыл бұрын

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 : )

@OzduSoleilDATA 6 жыл бұрын

WOW! You're going all in!

@excelisfun 6 жыл бұрын

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

@ammylove123 Жыл бұрын

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

@excelisfun Жыл бұрын

Glad they are helpful!!!

@zaafirc369 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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

@jleonard5106 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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 4 жыл бұрын

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

@ahmedal-dossary4386 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@michajlo86 3 жыл бұрын

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

@ismailismaili0071 5 жыл бұрын

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 5 жыл бұрын

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

@ismailismaili0071 5 жыл бұрын

I went to China it was great thank you.

@chunpak1811 4 жыл бұрын

Mike, Thanks for the amazing video. One question: What's the best way to put in a bunch of blank columns to match a file format? I can put in one blank column by adding a column but I don't want to have to do it over and over again. Thanks.

@tejak1886 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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 : )

@vida1719 6 жыл бұрын

Extremely good explanation. Just amazing.

@excelisfun 6 жыл бұрын

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 : )

@eladiobardelli3001 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@jitendratrivedi7889 4 жыл бұрын

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

@kebincui 3 жыл бұрын

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

@excelisfun 3 жыл бұрын

Glad it is amazing for you!!!!

@zaharterentev2091 4 жыл бұрын

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

@excelisfun 4 жыл бұрын

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

@FabioGambaro 5 жыл бұрын

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 5 жыл бұрын

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

@871340730 4 жыл бұрын

Thank you very much Mike! Keep Safe!

@sedarathnadcd Жыл бұрын

wonderful video with lots of new learning. thank you

@AlbrechtJ Жыл бұрын

Thanks for a great video. Very clear explanation.

@GROWINGBUSINESSESBETTER 2 жыл бұрын

I have not even started this video yet, but really hoping this will explain the difference between M Code and DAX. In my mind they are the same.

@khaledseghari1189 3 жыл бұрын

Another great video. Thanks Mike you are excellent teacher.

@excelisfun 3 жыл бұрын

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

@shubhampawar8506 2 жыл бұрын

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

@excelisfun 2 жыл бұрын

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 2 жыл бұрын

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

@ExceliAdam 6 жыл бұрын

As usual fantastic job and thorough discussion of the topic 👍

@excelisfun 6 жыл бұрын

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

@binhthai078 2 жыл бұрын

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

@excelisfun 2 жыл бұрын

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

@fabryespejo2697 5 жыл бұрын

Excelente video!! Muchas gracias por Compartir tus conocimientos. Saludos desde Argentina

@excelisfun 5 жыл бұрын

You are welcome, fabry!!! Thank you for your support from Argentina!!!!

@rrrprogram8667 5 жыл бұрын

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

@excelisfun 5 жыл бұрын

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

@rrrprogram8667 5 жыл бұрын

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

@larrycroce4874 5 жыл бұрын

I upload multiple file with the same format but for different products and tried creating a function using the M code from a formatted file so I could automatically apply that formatting to other files I upload by invoking the function. Much like you did for the automatic formatting of the bad tables. This would not work since the files I load are text files and I get an error with the table."transform function" argument. What type should "table" be named so this works on text files?