Power Query Masterclass on Lists with Oz du Soleil
Рет қаралды 19,539
Күн бұрынCheck out the M Language course and learn to push beyond the UI - goodly.co.in/learn-m-powerque...
• Split by Variable Colu...
In this video, we dive deep into Power Query and explore the fascinating world of the M language, specifically focusing on the concept of lists to make it easier for you to navigate and leverage its power in Excel.
Don't miss out on this insightful session with @OzduSoleilDATA, where we simplify the intricacies of the M language, empowering you to work smarter in Power Query.
Also, don't forget to check out Oz's Channel - / @ozdusoleildata@uczgov...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step-by-Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
00:00 Intro
04:44 About Global Excel Summit
08:08 What is a List?
10:09 Extracting Values as a List
16:41 Dynamic Expansion
32:40 Dynamic Unpivoting
43:29 Dynamic Splitting
50:30 The Advantages of Mastering M for UI-Oriented Users
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
#powerquery #mlanguage #excel
@GoodlyChandeep 2 ай бұрын
📌Check out the M Language course and learn to push beyond the UI - goodly.co.in/learn-m-powerquery/? Split by Variable Columns in Power Query - kzfaq.info/get/bejne/htFln7OTysnecX0.htmlsi=zmBTsovAeoS9X424 Also, don't forget to check out Oz's Channel - www.youtube.com/@OzduSoleilDATA
@Imwolfies 11 күн бұрын
List's demystified, in easy to understand steps of the "how" and "why" along with the utilization of the possibilities in "M" code. Especially for those of us that are new to "M" code and cannot do with what is needed in the PQ user interface. Absolutely excellent.
@alterchannel2501 2 ай бұрын
Chandeep is the BEST teacher ever. I really mean it. Nobody explains and makes things so easy like him.
@romulusmilea2747 2 ай бұрын
A Power Query titan teaches another Power Query master ! This is a dream that came true ! These are true professionals, who still want to learn from others, even if they are really valuable experts themselves. I have a dream for Chandeep, to become a Microsoft MVP as soon as possible, he deserves it a lot ! Oz, I really hope that you will endorse Chandeep in becoming a MVP !
@OzduSoleilDATA 2 ай бұрын
YES! Chandeep should definitely be an MVP.
@ismaelkourouma5558 21 күн бұрын
❤❤❤❤
@ismaelkourouma5558 23 күн бұрын
I really loved this video, seeing Oz like a young man learning something new. I know Oz since 4 years and I know he's a master. I can see in this video how he's humble and that is fundamental when you're learning something new even if you're an Excel MVP. Thank you guys for this phenomenal video. Really loved.
@Ypurenete 2 ай бұрын
Amazing video!!! When You have somebody to chat with during your presentation.
@stevenflax 2 ай бұрын
Usually love Chandeep's presentations. But having Oz asking questions and interacting was different level. Thanks both !!
@leebecker8255 2 ай бұрын
Yep, I totally agree, he is asking questions that we are thinking. It makes it much more realistic.
@OzduSoleilDATA Ай бұрын
@@leebecker8255🤗
@joaquimcosta952 9 күн бұрын
Very very very useful!!!! Thanks you for this subject.
@LakeSightSolutions 2 ай бұрын
Humility at its best!!! One expert learning / teaching another
@RobertLJ11 2 ай бұрын
Great Video! Loved it! I love to see the Teacher as the student. Everyone who is dedicating time to teach also should have time to be a student. Thank you for all of you videos! 😊
@jimgleason4040 2 ай бұрын
Chandeep. You are absolutely Fantastic as Always. You and Oz are a really great pair.
@OzduSoleilDATA 2 ай бұрын
🙏🏽
@ismaelkourouma5558 15 күн бұрын
Chandeep opened my eyes on how to watch M code. It’s just crazy 😅! I don’t know how many times I am watching this video. Thanks
@GrainneDuggan_Excel 2 ай бұрын
Wow! Wonderful video on so many levels! Thanks Oz and Chandeep. Chandeep, you deserve a medal if you can get Oz to do a video manipulating M code! Can't wait for the next Chandeep and Oz video!❤❤❤
@OzduSoleilDATA 2 ай бұрын
Great idea! 💡
@chrism9037 2 ай бұрын
Epic collaboration video!
@marcusdrees5155 2 ай бұрын
Hi Chandeep, I have just watched your video and once again I would like to express how thankful I am for your input you have unknowingly given me in the past. Not only have I become a member of your channel in the meantime, I have also enrolled to your M course earlier. As shown you have enligthened 400+ people other than me to take your course and I can tell all others that are still interested: It was worth every penny!!! Good for you!!!! I have watched quite a few of Oz's videos as well and I would like to ask you to do more videos like this because some things became so much clearer again (having taken the course) only because of the fact that you had Oz ask immediate questions, which helps a lot in the sense that rather that talking about a huge topic (Power Query) reduced to a specific case study in many videos it was easier for me having received answers to questions I would have asked myself which Oz did for me instead. I think with a certain amount of background and experience would bring other user's skills to another level. Thank you very much again! Marcus
@baskis69 2 ай бұрын
Fantastic masterclass! I love the way you explain it! .... thanks for sharing
@shirleymoreman6725 2 ай бұрын
2 of my favourite experts in one video! This is brilliant and so well explained.
@Nalaka-Wanniarachchi 2 ай бұрын
oh.This is huge ..PQ masters in action ...
@michaeloloishuro6915 2 ай бұрын
Great. This was one of the best chances for learning by some of us. The trust element is more because I am aware Chandeep is presenting to another Guru. Thank you!
@Ziggych 24 күн бұрын
Loved this video. Never knew how dynamic PQ can be
@allabout1135 2 ай бұрын
I liked to see that even Oz have things to learn. No meter how many Years we are on excel there is always what to explore new, optimize and get understand new concepts. Its not only about knowing tools and functionality but its more about how we use it and combining together on our daily problem solving challenges.
@OzduSoleilDATA Ай бұрын
Absolutely! There's always stuff to learn. I'm glad you appreciated this. I liked this role of being the learner.
@philipplanchenault9150 2 ай бұрын
Mindblowing ... the explained concepts ... but also the way Chandeep explained ...
@ExcelMoments 2 ай бұрын
I was present when this class was proposed at GES24 and to see it become reality is really cool. Chandeep, those were very brilliant examples showing use cases for lists. You have made an M-coder out of OZ 😁😁 keep up the great job
@OzduSoleilDATA 2 ай бұрын
🤗
@zhihaowu208 Ай бұрын
This was an amazing POwer Query a day video! thank you.
@OzduSoleilDATA Ай бұрын
🥳
@EricHartwigConsulting 2 ай бұрын
Fantastic video! I really like the break down in the steps you were taking in each example.
@mrbartuss1 2 ай бұрын
We definitely need more this kind of content
@ManthaarJanyaro 2 ай бұрын
Love how you build it up, Love from Sindh, Pakistan. Respect for you (both) guys.
@allabout1135 2 ай бұрын
What the amazing session. Thit approach by real life mentoring for me brings more understanding about topic like regular videos recorder by single person. In this format comes up natural question which comes up many of us. So Pleas keep and expand this format. Personally me find it very valuable. Good job booth.
@johnhackwood1568 2 ай бұрын
Very nice 'feel good' video Chandeep that captures the joy of learning as well as a first class explanation. And good on you Oz for being so humble and open to learning in the way we all should (always) be.
@OzduSoleilDATA Ай бұрын
🤗
@westleyempeigne6541 Ай бұрын
Amazing teaching and learning!
@gezin_longuevilleosaer4245 2 ай бұрын
This is so helpfull again, the real power of M, many thanks Chandeep.
@SergioAlbarran-dm8ty 2 ай бұрын
Two genious , it is like seeing John Lennon / Paul Mccartney (side A - side B)
@OzduSoleilDATA 2 ай бұрын
🤗
@ismaelkourouma5558 2 ай бұрын
Amazine Goodly. Thanks
@MrMoney-ig2hp 2 ай бұрын
Again, world class and thanks a bunch for this helpful informative video. Well put together!
@SP_Investments Ай бұрын
As usual amazing. Thank you for video
@godwinsiabukandu2196 2 ай бұрын
best lesson format, great teaching skills. great lesson
@barttitulaerexcelbart9400 2 ай бұрын
Hi Chandeep, this was an epic video! I really liked the way you explained all the small steps to Oz, so on a natural conversation. I saw many of your video's but this one really gave me an understanding of lists. My learnings: the UI does not work with lists, lists can prevent you from making all kinds of helper queries (making a spaghetti sometimes), you need some M code (formulas) to work with. I will start creating a list (!! ha ha) of the most important M-formulas to use. Thank you so much Chandeep. Hope you will make new video's like this.
@OzduSoleilDATA 2 ай бұрын
BART!!!!!!!!!!!
@damianocausale 2 ай бұрын
Great explanation. The best way to teach and learn Excel and ... the M code become simple 🎉 thanks Chandeep and thanks Oz
@tak0331 2 ай бұрын
Outstanding conversation and class. Chandeep, you are a smooth brotha!
@Negi_From_Pauri 2 ай бұрын
chandeep chabra = Goodly = Power Bi Deadly DAX Developer > Love u bro u made my level of confidence high in DAX.
@Negi_From_Pauri 2 ай бұрын
nobody can beat you in DAX in youtube
@3danim8r1 2 ай бұрын
Excellent video. Thanks for sharing.... and the funny Part OZ is scratching his head most of the times.
@OzduSoleilDATA 2 ай бұрын
YEAH! Lots of head-scratching but it got it. Chandeep was thorough and effective.
@Abdullah__Meshal 2 ай бұрын
@@OzduSoleilDATA Chandeep is very great but also your questions add deeper understanding. Thank you to both teachers.
@Abdullah__Meshal 2 ай бұрын
Thinking from right angle. Thank you so much to amazing video.
@ruzzputin 2 ай бұрын
Amazing!
@cjimmer4877 2 ай бұрын
Learned a lot. Thanks you guys
@user-ef4oc3vc6r 2 ай бұрын
Thank you very much. That was cool and interesting!
@jaiconruedas 2 ай бұрын
This is cool. Thank you for this 😁
@abdelazizallam 2 ай бұрын
amazing keep going
@IlaPatel811 2 ай бұрын
Thanks for the detailed explanation, it is so helpful!
@OzduSoleilDATA 2 ай бұрын
VERY HELPFUL!
@aman_mashetty5185 2 ай бұрын
Two legends at one place 👌👌👌
@OzduSoleilDATA 2 ай бұрын
🙏🏽
@unnikrishnansanthosh 2 ай бұрын
two greats in one video
@OzduSoleilDATA Ай бұрын
🤗
@JohnSullivan1 2 ай бұрын
This was good....
@aparnapandravada5073 2 ай бұрын
Great, Request to add more M query tutorials.
@williamarthur4801 2 ай бұрын
Really enjoyable, I do like Oz, BTW have you done anything with List. Alternate, I've used to to create a list for the offset for inserting blanks, with accumulate but to be honest List. Generate is easier, perhaps you could set a challenge to find a use. keep up the work
@gef24 2 ай бұрын
@ Oz, Chandeep says that hard-coded appears in red. So I think you may make your Iroquois-style crest more dynamic.
@GoodlyChandeep 2 ай бұрын
Hah. Let's stick to PQ 😂
@OzduSoleilDATA 2 ай бұрын
😁
@XcelMaestro 2 ай бұрын
Hi Chadeep, Your are awesome teacher I would like to have question regarding P-Query How we can use groupby function dynamically e.g. In Second example unpivoting column, how can we use group by function by excluding High only (Dynamically) if mid class added in row then this will show groupby of Low and Mid both classes. (may be Groupby with if statement I have no idea just guess)
@williamthedataprof 2 ай бұрын
This is fantastic, gentlemen! I was always confused whether you still need to wrap the list, say the ColNamesList in the video, inside {} What's your take? Are there scenarios where that would be needed?
@GoodlyChandeep 2 ай бұрын
Those scenarios will be for creating a nested list
@williamthedataprof 2 ай бұрын
@@GoodlyChandeep probably for another video 🙂
@rogerp6573 Ай бұрын
Nawww... it's cute how they gush over each other
@OzduSoleilDATA Ай бұрын
🥳
@gennarocimmino 2 ай бұрын
👍👍👍
@zulajenkins658 Ай бұрын
Hi Goodly. Thanks for sharing it. I am going to do your mastering M . Then you offered the 3 course bundle. Then there is an issue with your payment. It costs INR24480 but it converts to Australian currancy, then the payment asks it to pay US$. I am bit confuse with the currancy convert.
@GoodlyChandeep Ай бұрын
Can you please send me an email - goodly.wordpress@gmail.com I'll try to get your problem fixed
@chiragdabhi4929 2 ай бұрын
I want to make an automatic lookup value in your dynamic unpivot data example " sales date wise data". I want to be automated to lookup the latest date data at the end and make that data my raw data, and again, the next day I want to lookup the latest date data, and that data becomes my updated data. I always want to look up the latest date data, and that data will be my raw data for the next day. How is that possible in power query?
@ivanzhelyazkov6625 2 ай бұрын
Another great lecture, Chandeep. Thank you! P.S. Oz is probably the most overrated MVP in the whole Excel community
@SamehRSameh 2 ай бұрын
How can i check list if contain only specific items ???
@prasadshete9101 2 ай бұрын
Gr8 video got me subscribing to your channel. Can you tell me how to rename a column name by contacting the preceding column name. Basically each CSV file have the following two columns structure AreaName Available The area name varies where Available remains same and I want to change 2nd column name. For example If the 1st column name is Zomato then 2nd column should be renamed as Zomato Available. Notes Each file can have multiple 2-column structure. This is causing the PQ to rename Available columns as a table cannot have duplicate column headers.
@richardmensah3327 2 ай бұрын
no pratice file?
@niknoknak4006 2 ай бұрын
🔥🔥🚀🚀🧪🧪
@Wzxxx Ай бұрын
Great
@alanmonaghan9194 2 ай бұрын
Hi Guys I've just started working through this with you and after creating the table from the [Enter Data] button and adding the same data, I get the following code which doesn't look like yours - let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTJUitWJVkoCsozArGQgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Letter = _t, Value = _t]) in Source Any idea what's going on? Thanks, Alan
Goodly
Рет қаралды 22 М.
Goodly
Рет қаралды 35 М.
Excel Off The Grid
Рет қаралды 19 М.
From Zero2BI Hero with Stelian
Рет қаралды 2,6 М.
Goodly
Рет қаралды 19 М.
MAMU TECH
Рет қаралды 263 М.