Dataflows (Power Query Online) is introduced in the next video MECS #13 : ) There are a practice files for both Excel & Power BI Desktop! The practice files (homework) are in both files, but instructions are only in Excel file on the HW(1) worksheet.
@ExcelInstructor Жыл бұрын
Hi Mike great Video. 19:50 Probobly under 1 of my comments I already showed a solution for dynamic type pickup. so you can use exact same technique to rename columns. and when used with M code if statement you can create quite advanced way of renaming columns, including an excel Table which would have table column names and its renamed column.
@excelisfun Жыл бұрын
@@ExcelInstructor That is in the next video : )
@ExcelInstructor Жыл бұрын
41:53: When im trying to explain adding values in PQ as easy to understand example im using fraction addition. becouse when adding fractions denominator has to be the same for all the fractions that we want to add, so in a sense Power query "denominator" is the data type we are opereting on.
@excelisfun Жыл бұрын
@@ExcelInstructor That is a great example : ) : )
@ExcelInstructor Жыл бұрын
1:02:05 Q1: That's easy :) [Supplier] is the column name we are extracting values from, and {2} is 0-based position from the top of the list from the [Supplier] Column extracting actually position number 3. PQs 0,1,2 = to 1,2,3 :) 1:02:09: Q2: This is bit more complex but still very easy :) so let me break it down to parts: Part 1: the function itself: Excel.Currentworkbook() a function that return every readable object for PQ into a Table of values (ranges, named ranges, Printing ranges, Tables, objects from name manager and even printing areas) Part 2: the curly bracket: within it we have field access operator pointing to very specific record named "LookupExample" basically this creates a record that contains an object and a name. Part 3: [Content] that is pointing to specific column that is actually always the same for every imported document. this Column contains table object. so all this "mess" looks to every object in excel workbook, then searches for a specific record containing a Table, then the table is "extracted" from the record and displayed into basic table we can start working on.
@PavanLalwani Жыл бұрын
Mike you are teaching the whole world directly by your videos, indirectly by teaching instructors like me who are carrying this legacy ahead. You are truly amazing and best in the world . Inspiring !!!
@excelisfun Жыл бұрын
Yes!!! Love to hear this. It has been my goal for 15 years here at KZbin to provide free education for the world in hopes that it would spread and shower Excel efficacy and fun onto the world.
@ankursharma6157 Жыл бұрын
Pavan Sir, Like Mike, You are also helping countless People through Your KZbin Channel. We are Grateful to Mike and You 🙏🏿
@PavanLalwani Жыл бұрын
@@ankursharma6157 Ankur it's absolutely my pleasure doing this and seeing the change
@@PavanLalwani I did not know about your awesome channel!!! I just subscribed : ) Go Team!!!
@gvitullib Жыл бұрын
In my opinion, the best Code M step by step course I have watched so far. This 365 MECS series are like top ranked Oscar´s awards movies. Thanks a lot Mike !!
@excelisfun Жыл бұрын
You are welcome a lot!!!! Thanks for the Oscars, gvitullib!!!!
@qamaruddinkhichi904 Жыл бұрын
I'm speechless to see your hardworking, dedication, enthusiasm, and unconditional support to help us. Thanks a lot!
@excelisfun Жыл бұрын
Yes!!!! That has been my goal for 15 yeasr here at KZbin : ) : ) Tell all your friends about the free education here at excelisfun!
@qamaruddinkhichi904 Жыл бұрын
@@excelisfun off course, I'll, let me tell you whenever somebody asks me the best KZbin channel to learn Excel from. I always recommend this channel. I myself leanred from here.
@excelisfun Жыл бұрын
@@qamaruddinkhichi904 : ) : ) : )
@rrrprogram8667 Жыл бұрын
Top class video by a legendary man Mike Girvin.....thanks for sharing...
@excelisfun Жыл бұрын
Yes, RRR-Long-Time Viewer!!!!! You can watch and help, RRR: kzbin.info/www/bejne/aYvOeqqBd7uejKc
@QuantumIdeas9 ай бұрын
This is the most comprehensive Power Query/M Code video I've come across in KZbin so far, and I've already viewed weeks of Power Query/M Code videos already. I wish I came across this video a lot earlier and I could have saved a lot of wasted time.
@excelisfun9 ай бұрын
I wish you had too. But Google seraph is not determined by quality and value. Glad you found it!!!
@ruelformales5184 Жыл бұрын
Mike deserves all the praises in this comment. He is just in a different level!
@excelisfun Жыл бұрын
Glad you like this!!!!
@joedi Жыл бұрын
Mike honestly teaches for common person. I’ve paid for a lot of training and have learnt a lot but Mike just makes it so simple for all. If I ever visit the US,I’m taking this dude out for lunch!
@excelisfun Жыл бұрын
Glad it all helps! Can't wait for lunch ; )
@joedi Жыл бұрын
@@excelisfun definitely. If you’re ever in NZ visiting Chandoo, I’m local to where he lives. Lunch offer stands here as well. 😊
@excelisfun Жыл бұрын
@@joedi We could have a regular Excel Paaaaaaaaarrrrteeee!!!
@user-fn2rc7uc9b Жыл бұрын
I just dropped out from one of the top universities here in Korea and now I am focusing all my time and efforts in learning every detail of your lectures and your book. The difference in the quality is so outstanding that I feel ashamed even trying to compare. Thank you so much for your knowledge and effort, and more importantly your passion. I want to go back in time and slap myself who thought Excel was nothing more than a boring technology. I am trying to move away from all the fancy software engineering, machine learning, ai trend that I blindly pursue and am planning to focus the next several years on understanding and mastering Excel. Thank you so much and I hope you have a great day
@excelisfun Жыл бұрын
I am so happy to help!!!! It is 100% true for many decades: Colleges and Universities around the world have abjectly failed to proper train graduating students. Almost everyone must know Excel (especially in the data-driven decision era), but almost no graduating students are taught Excel. Maybe they take one high-ill-informed class in the matriculation process, but they ultimately leave the university without a key skill. This is why I became a professor over 2 decades ago. The funny thing is 2 decades have past since I became a professor, but there are still very few teachers in the world who are actually teaching students what they need to know, in this regard. I am super glad to help you!!!!!
@excelisfun Жыл бұрын
As you watch and study my videos, remember these are not free: I do change a thumbs Up for each video ; )
@Cracktune Жыл бұрын
good luck!
@GameboyMufti Жыл бұрын
Thanks for sharing , I am amazed how people like you are sharing such useful and precious knowledge for free. Thanks once again for sharing.
@excelisfun Жыл бұрын
I am happy to share free education for 15 years here at KZbin, to help people like you and the rest of the Team : ) You can help get this video to more people, just be sure to watch end of video: kzbin.info/www/bejne/aYvOeqqBd7uejKc
@josh_excel Жыл бұрын
When you use EACH, the _ represents the whole record or other object returned from each row and in many contexts, using _ is not required, but you can put it in just before the [ ] and it works.
@excelisfun Жыл бұрын
Thanks for that tip : )
@michaelt312 Жыл бұрын
I am as excited about this series as I was when my wife gave me the Marvel Infiniti boxed series. You are a greater hero than any of them. Thank you!!
@excelisfun Жыл бұрын
You are "Infiniti boxed" welcome for the series!!!!!!
@bucs2021 Жыл бұрын
This is 'next in line', excellence work of Mr Girvin. Tireless keeps giving us knowledge. Unbelievable. Thank You!
@excelisfun Жыл бұрын
You are welcome for the believable-unbelievable, Bucs 2003!!!!!
@ahmedaiad3372 Жыл бұрын
I would like to say to you that you provided almost all of the required basics for any one to start working based on power query editor and with little help of Copilot and chatGPT4 any thing could be done based on this knowledge provided in your video , in the End , that was a great video 👌👌👌
@excelisfun Жыл бұрын
Glad it helps! Contrary to many human's beliefs, if you don't understand M Code (or any given topic) well, Copilot and chatGPT will just get you in trouble.
@patrickschardt7724 Жыл бұрын
I am definitely not a Power Query expert. In the relatively short time I’ve been using it, I’ve noticed a couple things related to hardcoded values: 1. Avoid if possible by doing things like making a variable for the columns names 2. If they can’t be avoided, try to put those steps at the end of queries to reduce the number of steps that reference it in someway What a fantastic tutorial. I’ll have to get these notes
@excelisfun Жыл бұрын
Great advice!!! Yes, check out the notes, they should be good!
@excelisfun Жыл бұрын
Dataflows (Power Query Online) is introduced in the next video MECS #13 : )
@snowylau93284 ай бұрын
oh my gosh, that was a lot of content jammed packed into 1h 40 mins. I sat through it and followed along for the whole morning and afternoon. Great for beginners, the pace at the start was great, lost you there a bit during the Custom Functions part where there was 5 methods 1:24:42 , went to rewatch and rewatch at a slower speed (I usually use 2x so went to 1.5x or 1.25x) And then, just as I thought I was back on track, during the last 5 mins of the double "each" part and the 3 different ways to write a match lookup function in the advanced editor, it lost me, 1:36:16 , due to the tabs and spacing, but I went to your "12-M365ExcelClassFinished" file and slowly untabbed and read through each line and rewatch your video and it helped. Really great teacher! Will just need some time to process everything after absorbing all that content at one go and I will definitely go back to this video for reference along with your word document whenever I need help to refresh concepts again. Brilliant M code tutorial!
@excelisfun4 ай бұрын
Your study methods are perfect for people who REALLY want to learn. I put so much all in one class: long videos, files to practice, finished solutions, pdf notes. But only those that take 10 to 30 hours of concentrated study will come away with good skill. Awesome stragey, Snowy!!!!
@snowylau93284 ай бұрын
@@excelisfun yes, I appreciate all the comprehensive files and notes! Thank you!
@nadermounir8228 Жыл бұрын
The best Video on M-code on the Internet for sure. The PDF notes are superb. Couldn't have learned excel without Mike Girvin :)
@excelisfun Жыл бұрын
Thanks Nader : ) : ) : )
@HuTrzy5 ай бұрын
It's hard for me to even express how grateful I am for such a great piece of work... Thank you so much !!!
@excelisfun5 ай бұрын
You are welcome so much! Tell all your friends and colleagues : )
@KuldeepSingh-nq1vi Жыл бұрын
No other video is available like this in respect to M Language.. Thanks for making this descriptive video..
@excelisfun Жыл бұрын
You are welcome for the description!!!
@MerkDolf Жыл бұрын
The good thing about epic videos are that you can go back over and over again, plus with the addition of time stamps great thank you very much.
@excelisfun Жыл бұрын
That is exactly why I make them: time-stamped one-stop shopping!!!! The problem is, the vast majority of Excellers do not like long videos. They want a quick answer. And the KZbin/Google algorithm hates my videos and does not promote them well... But for smart people like you: Bam!!! I got you covered ; )
@kamalsh123 Жыл бұрын
This video is great. i am using power query for about 5 years but this video taught me all new aspects of it. thank you mike
@excelisfun Жыл бұрын
I love to hear that!!!! With M Code you will have so much more power. Next video has lots of M Code tricks too : )
@kiwikiow Жыл бұрын
I like the way you teach M Code step by step. Video and all files you created are awesome. 👍👍 Thank you very much Mike 🙏💚
@excelisfun Жыл бұрын
You are welcome very much! pdf files, Excle files and videos are ghostly fun ; )
@christellelemaire9749 Жыл бұрын
Coucou 🧡💜❤️❤️💙💙❤️🧡💜❤️❤️💙💙❤️🧡💜❤️❤️💙💙❤️🧡
@excelisfun Жыл бұрын
@@christellelemaire9749 : ) : ) : ) : )
@hBrynx10 ай бұрын
I’m glad I already watched your video on LAMBDA worksheet function. It really helped to link the related concepts from that video to this one. This is high quality learning material! 👏
@FutureCommentary1 Жыл бұрын
Commenting for the algorithm.
@excelisfun Жыл бұрын
: ) : ) : ) : )
@johnlug96556 ай бұрын
Awesome Explanation and exploiting many uses of implementation. Very thorough and exemplary!!
@excelisfun6 ай бұрын
Glad you like it!!!! Tell all your friends about the high caliber and that it is free: they won't believe it lol
@anthonygeo3 Жыл бұрын
Literally just started using power query this week and have a development goal for the year of learning power BI. Thank you for uploading!
@excelisfun Жыл бұрын
You are welcome, anthony!!!!!!
@beingrishi64508 ай бұрын
Absolute exceptional
@JLyck Жыл бұрын
Appreciate what you have taugth me in this video and the others! Mange tak.
@excelisfun Жыл бұрын
Thank you VERY much for your kind donation!!!! It really helps me to keep going : ) : ) : )
@enrikdp9318 Жыл бұрын
Thanks for your amazing Excel content. Very helpful to become an Excel Wiz.
@excelisfun Жыл бұрын
Yes indeed: M Code makes great Excel & Power BI Wizzes!!!!
@B1897forzajuve Жыл бұрын
You made my day Mike. Thank you very much.
@excelisfun Жыл бұрын
Yes!!!!! Makinbg Days is THE best : ) : ) Tell all your friends who want to learn M Code : )
@Sou9856 ай бұрын
This Channel is a goldmine! Thank you!
@excelisfun6 ай бұрын
You are welcome !!!
@MrChevago Жыл бұрын
Thanks for sharing. This is the best class I 've ever seen. I like the way you teach a real Master.
@excelisfun Жыл бұрын
You are very welcome!!!!
@daviddevita5 ай бұрын
Duuuuuude! I've ben begging for a video like this!!! Thanks a ton!!!
@excelisfun5 ай бұрын
You are welcome a ton!!!!!
@roywilson9580 Жыл бұрын
Thanks for the interesting intro to M Code, it is certainly a powerful way to use the Power BI application to clean and prepare data ahead of analysis. Love the way you give clear and concise explanations with multiple examples and your boundless enthusiasm for the subject matter. I like that power query makes you think more about data types and how the data is structured versus how to achieve the required structure and have noticed that with the newer functions in Excel that Microsoft seem to be pushing for a more highly structured approach to data on the grid which can only be a good thing.
@excelisfun Жыл бұрын
Only a good thing! For sure : ) Glad you like the video, Roy! In the next video we will see how for even mundane topics like connecting to a data source and importing data, if we know some M Code we can do some magic things!
@alterchannel2501 Жыл бұрын
This is in absolute the best video and the best explanation I have seen and heard online. It's a PowerTutorial that Data Meshed all my confused knoledge of M code and cleaned it and put it in Steps in my mind. Thank you so much
@excelisfun Жыл бұрын
You are welcome. I love how you said this: "Data Mashed all my confused knowledge of M code and cleaned it up and put it in steps in my mind"!!!! : ) : ) : ) : ) That is EXACTLY what I have tried to do with the MECS class and these very long one-stop shopping videos: for a given topic: put the important elements of a given topic all in one place, and present it in an order that helps to make the complicated, less complicated : )
@alterchannel2501 Жыл бұрын
@@excelisfun ☺
@excelisfun Жыл бұрын
@@alterchannel2501 : ) : )
@sandeshjoshi7470 Жыл бұрын
Thanks for sharing the same, waiting for such video for a long time 🙂
@excelisfun Жыл бұрын
You are welcome for the share!!!
@sumardjo3 ай бұрын
Waooo... Completed to simple file and step by step thanks very much... thanks ....
@excelisfun3 ай бұрын
I have a new version of this video and its even better. It comes out tomorrow.
@chrism9037 Жыл бұрын
Awesome Mike! I definitely need to get better with M code to take my PQ abilities to the next level. Thanks for another great video!
@excelisfun Жыл бұрын
This video should be good for an M Code launch into Power Query awesomeness!!!!
@imranmlk79 Жыл бұрын
Excellent work and easy to follow!
@excelisfun Жыл бұрын
Yes!!! Glad it helps : )
@paspuggie48 Жыл бұрын
I tweeted a link to this video Mike. It's the least I can do, I mean the first PQ video I ever watched was by you 5 years ago and I've never looked back 🤘
@excelisfun Жыл бұрын
Yes!!!!! 5 years of Power Query fun!!!!!
@excel_along_the_way Жыл бұрын
Hi Mike, late to this party but thank you for this tutorial. Much appreciated.
@excelisfun Жыл бұрын
Paaaaarrrrrrdeeeeee!!!! Welcome to the party, Lester!!!
@SyedMuzammilMahasanShahi Жыл бұрын
Awesome Mike with another EXCELlent video. Thanks for the share.
@excelisfun Жыл бұрын
You are welcome for the share, Fellow Teacher!!!!
@zt.5677 Жыл бұрын
A genius video. All in one on M Code. I wish I could like it more than once. Thank you.
@excelisfun Жыл бұрын
Thank you for the many Thumbs Ups : ) : )
@zoranmilokanovic6229 Жыл бұрын
Huge like for the video! Keep up the good work!
@excelisfun Жыл бұрын
Huge thanks : ) : ) : )
@johnhackwood15684 ай бұрын
Thank you Mike such a broad topic handled so thoroughly and well.
@excelisfun4 ай бұрын
You are welcome, John!!!!
@garudabowo2 ай бұрын
Sir you are amazing teacher
@excelisfun2 ай бұрын
Thank you : )
@Faisal63045 Жыл бұрын
Thank you, i fall in love with Excel because of you
@excelisfun Жыл бұрын
You are welcome! Glad you love it : ) : )
@AmirEdalatCa10 ай бұрын
Amazing work! Did a fantastic job in preparation and presentation and the content is really helpful!
@unigirl123 Жыл бұрын
I wish this came out much earlier, but still watch the whole thing to fill in my knowledge gap. Thank you !
@excelisfun Жыл бұрын
I published a video almost exactly in my MSPTDA class like this back in 2018: kzbin.info/www/bejne/hISUcqmci551m6s Where where you, unigirl lol BUT: The good news is: better late than never. I hope all the M is great for you! P.S. when did you discover my excelisfun channel? What topics do you want? What field do you work in?
@unigirl123 Жыл бұрын
@@excelisfun oh wow back in 2018 ? How could I miss that one ? I watched your channel a while back and somehow it fell off my radar lol but good to be back now. I work in aviation so a lot of non-accounting stats that I do besides the typical financial. Is there a way that power BI / Power Query can convert different PDFs to a table ? I get weekly pricing notifications from different vendors sending in PDF so if I somehow can drop the PDFs to a folder, refresh the table and get the weekly summary, that would be amazing. Thank you !
@excelisfun Жыл бұрын
@@unigirl123 Yes - the next video in this class is all about importing data with many examples. There is one pdf example. BUT: there is one HUGE problem with your situation: by definition, pdf files are not designed to carry data from one system to another, like csv, txt, Excel, xml, json files. So there is NO way to guarantee that results are correct with file types like pdf and picture. Not only that, but the from Folder Feature (which would be perfect for this) can't interpret pdf data in a reliable way... Your situation is an example that plagues the planet earth: most people are ignorant about the structure of data. In a data driven decision world, this is a HUGE problem. The solution is to have the tables sent as csv or txt or some other file format where an easy solution can be created.
@tibibara Жыл бұрын
An excellent tutorial (again :) ) for the PQ/M, even for experienced users! 💯Thank you very much!🙏
@excelisfun Жыл бұрын
You are welcome very much!!! As an experienced PQ/M pro, what things in the video were helpful or what did you learn?
@tibibara Жыл бұрын
@@excelisfun ☺😇 I'm not a pro 😁, but I've already implemented a few semi-automatic solutions with PQ in a corp. environment. In the last 2-3 years, I've completed a few PQ courses, some of them were comprehensive, but somehow your approach, teaching method and your way of thinking is much closer to me, not only in that topic, but also in the others. For example, the LOOKUP methods were not explained so well and understandably in any course. In fact, there was no mention of it anywhere in this context: analogously to excel (INDEX fx). This tutorial made the whole picture and syntaxes much more understandable and clear, which so far I haven't used 100% consciously. (I mean here copied sources.) So thanks again :) I'm already excitedly waiting for the next part MECS13, I'm planning that for the weekend :D :D :D
@excelisfun Жыл бұрын
@@tibibara Yes!!!! The next few MECS are all about Power Query and M Code. You should enjoy. I am glad that the stories that I tell to try and make complicated things less complicated work for you : )
@yordanosadigo Жыл бұрын
You are always my best !
@excelisfun Жыл бұрын
Glad to help!!!
@mrcoffeeguystv Жыл бұрын
Thank you for your service and tips sir you are the best
@excelisfun Жыл бұрын
I am so glad to help!!!!
@emarcos40 Жыл бұрын
Great input. Thank you for your support.
@excelisfun Жыл бұрын
You are welcome for the support!!
@kevinmcmullen5009 Жыл бұрын
Thanks for sharing - this is so well done. I've been using Power Query since 2014, and I still learned a ton! ... M = data Mashup, who knew! :-) Great video Mike!
@excelisfun Жыл бұрын
Glad it was helpful!
@shubhampawar8506 Жыл бұрын
M Code by Master Mike ❤️ I always used to get confuse in list within list ..but now I understood it thoroughly . Thanks a lot ❤️
@excelisfun Жыл бұрын
Yes, the little details of M Code will make you a master. As soon as we se the ingenious beauty of how a list within a list is used in the Group By feature to get the 1) name of the new columns, 2) aggregate calculation, and 3) data type: BAM!!!! It makes prefect sense. This is a good example of why it takes so long to make videos like this (this one took 162 hours). I have to search and hunt for the perfect examples that illuminate the meaning of a certain topic, then I have to string together the related topics in the right order so it is smooth and easy to understand. Further, in the section of the video about lists, after I completed the filming and editing for the list section, I had to come back two times to insert new examples to help flush out the beauty and power of lists. You are welcome a lot, shubham!!!
@shubhampawar8506 Жыл бұрын
@@excelisfun Hats off to You ❤️..162 hours OMG ...You are really a true Excel Master. I luv the way , you are teaching anybody who has little knowledge or no prior knowledge can easily understand ❤️❤️
@excelisfun Жыл бұрын
@@shubhampawar8506 That is one of my specialties as a human. Since I am not that smart, and graduated High School illiterate, and had to learn as a dumb adult how to do things. I get it. I can build stories to make complicated things less complicated. My stories make few assumptions. My storied try to anticipate all questions and place the answers into the story in the right order. This is why the videos and stories take so long to make. I plan a story that even dumb people like me can understand. Although PHDs and Engineers and Mathematicians can all watch my videos and learn stuff (they are the ones who could understand it if I made lots of assumptions and let out details), I try to make my video stories so that we all can understand, learn, gain power and have more fun!!!!
@shubhampawar8506 Жыл бұрын
@@excelisfunYou are Intelligent and Smartest person for me ❤️❤️Lots of respect for You ❤️
@excelisfun Жыл бұрын
@@shubhampawar8506 : ) : ) Hard work and determination can get us anywhere : )
@williamarthur4801 Жыл бұрын
I wish you'd done this a few years ago , a great resource for anyone starting and a good refresher, I always forget records don't need " " , really looking forward to functions, usually muddle through but never know when to start with a variable, or with let and then the variable or if it needs to b for table or column. Now my head hurts. Thank you once again.
@excelisfun Жыл бұрын
I did make a video almost identical over 4 years back: MSPTDA #9 : ) I thought you already watched the MSPTDA class. Anyway, this MECS video #12 has all the content from MSPTDA #9 but it is presented in a smoother and more clear story : ) I got you covered in this video if you want to learn Custom Functions, william! P.S. sorry about the head hurting : )
@williamarthur4801 Жыл бұрын
@@excelisfun Seen it, but thanks, the msptda series was incredibly thorough, really enjoyed it.
@williamarthur4801 Жыл бұрын
@@excelisfun Yes loved the msptda series, my problem with custom functions is when writing from scratch, not converting, and when to to be used by using 'invoke custom function' to act on a column, or when to have a table function select the function and then select the table to act upon, I've done both but never quite sure which I need without experimenting.
@excelisfun Жыл бұрын
@@williamarthur4801 If I understand you correctly, I just create reusable functions (invoke custom function button) when I have to use the formula more than one time. Otherwise, I just write it in the column.
@williamarthur4801 Жыл бұрын
@@excelisfun Sorry for not getting back soon, this is the sort of thing I meant, this is for a running total after having grouped the date, so when converting delete all before index; (RunningTotal as table)=> let #"Added Index" = Table.AddIndexColumn(RunningTotal, "Index", 1, 1, Int64.Type), #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each List.Sum ( List.FirstN(RunningTotal [Units], [Index]))) in #"Added Custom" this works on the column, but this one renames headers with what's (Goodly Challenge) in first two rows, and (i think), needs the 'as table' ; then select the function and the tabel to work on in drop down; oh, he used Table.Record but I like this. (NewN as table ) => let NewName = List.Zip( { Table.ColumnNames(NewN), List.Transform( Table.ToColumns( Table.FirstN( NewN ,2) ),(_)=>Text.Combine(_," ")) } ), Custom2 = Table.RenameColumns( Table.RemoveFirstN( NewN , 2), NewName ) in Custom2 I shall stop now, and thank you for taking the tiem to reply.
@richardhay645 Жыл бұрын
Great video. Definitely took a fair amount of elapsed time and several settings to get through!! There has been a shortage of available videos on PQ so this one is a valuable addition. Maybe the subject of your next book?!?!?
@excelisfun Жыл бұрын
Glad you like it, Richard!!!! Yes, not many videos on KZbin about M Code. I am stumped from a marketing perspective, cuz I can't seem to get a free video like this out to people, and the google algorithm hates most videos that I post. Too bad good free material doesn't get to more people. I would love to write a book about PQ and M Code. I am planning to, but I always am so slow at things these years... lol
@sanjeevsoni6793 Жыл бұрын
Excellent, short videos cover the lot of M Code Topics
@excelisfun Жыл бұрын
Glad it is EXCELlent for you. But I do not understand what your comment means? "short videos cover the lot of M Code Topics "
@morenabalatseng8003 Жыл бұрын
May God bless you Irvin
@excelisfun Жыл бұрын
I hope you will like the video : )
@morenabalatseng8003 Жыл бұрын
@@excelisfun I like it. There isn't a video that you have made that I have watched and has no practical application in my life. You are the gift that keeps giving. Thank you Sir.
@excelisfun Жыл бұрын
@@morenabalatseng8003 You are welcome for the gifts!!!! Just keep watching, learning and clicking that thumbs ups : ) Tell all your friends too!!
@AhmedElShafeey6 ай бұрын
Stunsing as always ❤❤
@excelisfun6 ай бұрын
Glad this M Code fun helps!!!!!
@dantobuscus83105 ай бұрын
Hi! So for 39:41 the reason why we cannot do something like =[End] + [DaysToAddToEnd] is because they are different data types (Date and Number) right? But I’m confused about that because aren’t Dates really numbers in both Power BI and Excel? Or does Power Query not consider them numbers and instead their own data type?
@excelisfun5 ай бұрын
Yes, they are both numbers, but Power Query and M Code is so completely different than the Excel worksheet. In M Code, you must learn about how the different data types interact with each other, and adding a number and date is not allows because of the different data types. : )
@HoaiNam15117 ай бұрын
thank you for your share. You help me solve my problem.
@excelisfun7 ай бұрын
You are welcome!
@sr57264 ай бұрын
thank you so much. Learnt a lot
@excelisfun4 ай бұрын
You are welcome, SR!!!! P.S. In the sports of BMX, Skateboarding and Boomeranging, SR means Stay Rad : )
@darrylmorgan Жыл бұрын
Boom!Real Fun Class,Picked Up Some Amazing Tips...Thank You Mike :)
@excelisfun Жыл бұрын
Glad you got some tips, Bike Brother!!!! What tips did you learn?
@mrtharunprao Жыл бұрын
Thank you for this session
@excelisfun Жыл бұрын
You are welcome for the M Code session!!!
@DIGITAL_COOKING Жыл бұрын
Hi Mike, I have a weird question (if you don't mind). Can you tell me briefly about your daily schedule?" 🙂🙂
@mcwahaab Жыл бұрын
This is so excellent and insightful, Mike. You are really making a difference and we appreciate
@excelisfun Жыл бұрын
Glad you like this MECS class!!!!
@mr.chinmayajoshi2688 Жыл бұрын
Added to playlist! Thank you for your efforts. ❤️❤️❤️
@excelisfun Жыл бұрын
You are welcome for the efforts!!!!!
@RetroDree Жыл бұрын
This is Amazing. Thank you so much
@excelisfun Жыл бұрын
You are welcome so much!!!!
@einoconsult5563 Жыл бұрын
Mike :) at 39:52 I am French and my regional settings are set to France as well, when I chande the type if the first column to Date (using US locale) I get the format DD/MM/YYYY. But in your case I would maybe suggest to use the Date.ToText with the format and culture options to display the date the format you want
@excelisfun Жыл бұрын
I think you can use Data Type Using Local and get the dates to work.
@onsaelijulius4090 Жыл бұрын
Thank you so much Bro ,Great appreciation will follow each steps for M code
@excelisfun Жыл бұрын
You are welcome, onsaeli!!!!
@mrashid2292 ай бұрын
I just watched few minutes and find it a very easy to understand/follow lecture. Thank you indeed for the nice presentation. Just one question before I go further, Does this apply to Office 365 ᴏɴʟʏ?
@excelisfun2 ай бұрын
No. M Code has been basically the same since it came out.
@dacsontran5813 Жыл бұрын
Thank you for sharing it!
@excelisfun Жыл бұрын
You are welcome!
@martyc5674 Жыл бұрын
This is the one I’ve been waiting for!!
@excelisfun Жыл бұрын
Yes!!!!! All throughout the month long production, this video has been waiting for you too, Martin ; ) P.S. tell all your friends too : )
@dantobuscus83105 ай бұрын
So for 1:27:37 based on that definition, the reason why at 1:34:55 we have to not use each again, but instead make the custom function (IT) is because if we use each again, it would refer to the underscore operator _ again and now the underscore operator doesn’t know whether _ refers to the records in AddDataTypes or the records in disDiscount. Thus, that’s why we need to make a custom function (IT). Am I getting this right? Thank you in advance!
@excelisfun5 ай бұрын
: ) Yes you are!!!!!
@aperxmim Жыл бұрын
Thanks!
@excelisfun8 ай бұрын
Thank you very much for the donation!!!! M Code is fun : )
@rtrbs8383 Жыл бұрын
Thank you very Much .....Sir...
@excelisfun Жыл бұрын
You are welcome very much!!!!
@MagicOfMushroomsАй бұрын
I didn't know you could pull spilled array formulas in through power query!
@gabrieleranucci6425 Жыл бұрын
Well done video! It taught me a lot. Where can I download the pdf file you are referring to in the video?
@excelisfun Жыл бұрын
The link below the video has the zipped folder with all files.
@subbu_ca Жыл бұрын
This is just amazing
@excelisfun Жыл бұрын
Glad you like it!!!!
@nourreldeenmohamed367 Жыл бұрын
Mr Girvin which is better to automate tasks in excel, python tools like ( xlwings and pyxll ) or VBA which one I should go with
@excelisfun Жыл бұрын
I am not skilled in those areas. I cannot answer your question. Sorry.
@raymondso4734 Жыл бұрын
useful video, thanks for sharing
@excelisfun Жыл бұрын
You are welcome for the useful share : ) : ) : )
@martinpaulbannister1745 Жыл бұрын
Fantastic video. Thank u Mike 👍
@excelisfun Жыл бұрын
You are welcome, Martin!!!!
@temidayoadebiyi7024 Жыл бұрын
Finally the first to comment 😁😁😁😁
@excelisfun Жыл бұрын
Yes!!!! First Place Trophy for you, Temidayo!!!!
@ExcelInstructor Жыл бұрын
Congratz :)
@excellearner6311 ай бұрын
Thanks so much Teacher!
@davidjefferson6986 Жыл бұрын
Great video, thanks
@excelisfun Жыл бұрын
You are welcome!
@nileshvakharia4547 Жыл бұрын
Thanks a lot for this video Sir can you please give a link of video ,as I had watched earlier but don't remember now and need to refer the same, where you have explained how to fetch discount amount where there are three columns, 1. from no. Of units,2. To No. Of units and 3. Disc rate
@majidramzan6702 Жыл бұрын
Thanks, sir, for your efforts
@excelisfun Жыл бұрын
You are welcome!!!!!
@xiajunjim Жыл бұрын
Appreciated your huge effort Mike!
@excelisfun Жыл бұрын
You are welcome for the hugeness ; ) Tell all your friends about the fun!!!
@lucianoriquet85528 ай бұрын
Fantastic
@MalinaC Жыл бұрын
I'm absolutely amazed. Thank you Mike 👏🏆🥇. Thumbs up 👍 You are my number 1!
@excelisfun Жыл бұрын
Thanks, Teammate Malina!!!! : ) : )
@vaibhavgond Жыл бұрын
Thanks for sharing Mike.
@excelisfun Жыл бұрын
You are welcome!!! Tell all your friends : )
@vaibhavgond Жыл бұрын
For sure
@jhaanand81 Жыл бұрын
Just wow🎉
@excelisfun Жыл бұрын
: ) : ) : ) : )
@joedi Жыл бұрын
In NZ, the type number doesn’t use the term nullable in front the data type
@excelisfun Жыл бұрын
You can add it, though.
@HusseinKorish Жыл бұрын
Amazing Mike ... this is what i was waiting for ...Thanks alot
@excelisfun Жыл бұрын
Yes!!!! The wait is over. Watch and be happy, Hussein!!!!
@HusseinKorish Жыл бұрын
@@excelisfun Yes Sir
@excelisfun Жыл бұрын
@@HusseinKorish : )
@Anthony_Lecoq Жыл бұрын
Thanks mike, great big video, always something new to learn ;)
@excelisfun Жыл бұрын
You are welcome, anthony!!!
@masoudas2196 Жыл бұрын
Thanks
@excelisfun Жыл бұрын
You are welcome!!!!!
@eladiomendez8226 Жыл бұрын
Yes!!! You are awesome
@excelisfun Жыл бұрын
Thank you!!! I hope you enjoy the M Code fun and will tell all your friends : )