7 MIND BLOWING Power Query Functions (Beyond the User Interface)
ฝัง
- เผยแพร่เมื่อ 5 ก.พ. 2025
- 📘 Grab your copy today → goodly.co.in/p...
and get 4 hours of bonus lessons worth $150 absolutely free!
In this video, I'm going to explain 7 of the most important Power Query functions that help you go beyond the user interface and solve advanced data cleaning problems. The video is divided into three parts:
Part 1: Enhancing UI Functions: We'll explore how to tweak built-in functions like table.addcolumns and table.pivot for custom solutions.
Part 2: Beyond the UI (Core M Functions): We'll dive into powerful M functions not found in the UI, including table.group, table.skip, table.twocolumns, table.fromcolumns, and list.transform.
Part 3: List Transformations & Automation: We'll focus on list.transform in detail, showing how to automate data transformations, handle errors with the "try keyword," and dynamically generate lists for tasks like unpivoting.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/7...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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!
📘 Grab your copy today → goodly.co.in/power-query-book/
Download the File ⬇ → goodly.co.in/7-mind-blowing-power-query-functions/
I want your book in french please
Why hindi audio track is not available
"Never learn the functions themselves, Always learn their behaviour"... Best video till date to get a grasp of dynamic transformation.
- List transform columns
- Record transform rows
Brownie points... Little trick you showed by substituting 'each _' revealing the required inputs.
These are awesome tricks and a treasure for any Power Query nerd.
Thanks alot! Chandeep
Just purchased your M language ebook, and I can't wait to dive into it!
Good luck with the new book, Chandeep! You are my GURU!
Just downloaded your book. Eager to start reading and above all practising . Goodwork Chandeep keep it up.
Thank you for producing these videos. You explain concepts very well and I have purchased your book and look forward to digging in!
Just ordered the Power Query book!
This video has opened a new dimension to the standard UI options in PQ for me. Thank you. I'm eager to learn and use more of these useful features.
Let me know what you think of the book.
Love seeing PQ videos from you Chandeep!
Very good.
Fabulous video once again. I’m going to get your book this weekend, finally
Great content like usual!
Just got the E book - a quick scan and it looks super!!
Let me know how did you like it?
As a amatur starting from scratch I guess I've seen all your videos the last year. This i the one that made med understand the basic concept! I wish I saw it a year ago.
Wowowow, maybe the greatest video I have ever seen on PQ.
Really awesome.
Please, tell me it how it is possibe to order the hard copy of your book from EU.
Great explanations in every video! Thanks!
Great video and I have ordered the {M} book from you. You not just teach PQ but also teach the logic and mythology behind PQ.
Thank you for sharing your knowledge Chandeep! I also bought your E-book to support your excellent work ;)
Just bought your ebook! I'm super excited 👌🏾
plz let me know how did you like it?
Thanks
thank you so much
Absolutely amazing ❤🎉
Excellent! Thank you!
Amazing..as usual...
Thank you😊
Hello Chandu, big fan of yours. Really like the way you explain problem statement and solutions.
Kindly provide UPI pay option to buy your book for Indians.
Can you do a video on multiple find and replace options using Power query or simple dax. I have more than dozen names to replace for some or other reason and steps length is too long to perform.
Hi Chandeep
Thanks a lot for your videos..have learned a lot from them..Bought your ebook as well..
I have a request to bring back your PQ Battles Series.. Are there any new videos planned in this series ??
So so so good!
Me too. Got your book! Great.
class, as always
Awesome!
great💯
first of all, let me tell you that I love your videos.
will your book be available in France?
Hi chandeep , love your videos , is there a video you already made for version history of sharepoint list gathering using power querry ? or can you please make on that for better optimistaion
ellegantly usefull
Hi Chandeep, About Table.skip situation, if the value also have null record , how should we adjust the query
While using the condition for removing top rows, will it affect if any of the value in the table content is null ?
One of the most fundamental tuto you 've ever done to make us understand the power of power query... Beyond the ui.🪄🪄🪄👏🏼👏🏼👏🏼💪🏻💪🏻💪🏻💪🏻🙏🏼🙏🏼🙏🏼🙏🏼
Hi Chandeep,
I love your content. I bought the book when you first announced a number of weeks ago, and I got a link to download the digital version, which I did. 2 questions: 1) is the extra content you mention in the digital version? 2) will I get a hard copy of the book?
drop a mail to pratik@goodly.co.in to get the bonus.
if you want the hard copy you'll have to buy it when it comes out on Amazon
Fortunately I could get the ebook as the hard copy is not available in my area. I am eager to explore great tips and tricks in Power Query via the book🎉
I work in the construction sector. I'm the only one using power query in my entire project.
This video is quite humbling to tell the least
The good part about list.sum - it does not require to coalesce null values if you happen to have nulls in the table.
Excelente tutorial. Muchas gracias. Una duda: respecto al tutorial número 1: si añadimos un nuevo campo de texto, no funcionará. ¿Cómo podríamos elegir qué columnas sumar, descartando las columnas con datos de tipo texto? Gracias de nuevo.
Sir a very humble request could you please make a video on data modeling in power bi like how it works what actually happens when we make connections how tables joins (like in sql) and how filter flow works it would be great learning if you can explain this in excel using 4 or more tables ..Please sir no one has explained the data modeling connection in this way.🙏
Wonderful ji
19:51 Question: Is it better to reference a list (query) outside of your query, or to add a step to your current query, referencing that step which is just a list? I was just wondering - because it seems that the later was how you handled this in your M book (at least through Chapter 1 - the list chapter).
Hi, thank you for the wonderful lesson :)
would you please guide on
How to use Power Query to combine data from multiple HTML files containing multiple tables stored in SharePoint
I want to take an advanced course , do you have any upcoming courses
Cool can't wait to receive your book across pacific ocean
Hi, can I get a printed hard copy of your Power Query book in Malaysia?'
23:37 What if you wanted to keep the FALSEs - the ones which ARE dates? Thanks!
For those who would give this a downvote... schedule yourself for an immediate CAT scan to see what's wrong with your brain. We are concerned for your well-being.
Hello il like this video. i want buy your book but i m french and i séance for books in frech not in english.😢😅
Good job for you tube channel.
Good trick
But I have more than 2 text columns then how can I skip all the text columns ?
18:43 Technically, it is now 3 lists within one (1) list! 😉
Unbelievable 🤔
I have pre-ordered your book through amazon last night but I couldnt find a way to get free bonus lessons unfortunately. Can you guide me please?
drop a mail with the purchase receipt to book@goodly.co.in
We'll set up your bonus access
@@GoodlyChandeep I did, thanks for response
You're requested to upload this Video and such type of videos may uploaded on Desi Goodly Channel
Thanks ❤
I haven't gotten too far into the book yet. I don't get previews of the list's contents. What setting am I missing? No luck searching on Google, none of the fixes seem to work.
Youll have to click on the empty space next to the list value. It should show up
@@GoodlyChandeep Thank you very much, I think I was actually clicking on the list.
And if we want to add the data at column level
How can I fetch SharePoint access groups (name) applied to each folders and sub-folders in my SharePoint Document Library. Is it possible to get this information into excel via Power Query. If possible, kindly make a video on this.
How I get this book in Pakistan
Why hindi audio track is not available
Table.List or Table append row not every Table list or Table append column is possible power query please upload video
Hi I want to import the data from the website which has having username and password
Can you please guide us 🙏
I have a user ID and password with me
Sir hstrak table as table query one table
Hi chandeep
If column 1 have duplicates then
Don't Rush the video... Both speech and functions on excel are rushed too much
With this video i got confused with _. When _ creates Record Or Table or List, can you please help?
When creating the column names with Table.FromColumns and Table.ToColumns, is this better that a Table.RenameColumns(List.Zip(Table.ColumnNames(xxx), Table.ToList(yyy)), ?