M Language Tips to achieve more with Power Query – T0020

The tools offered by Power Query Editor are enough to solve most problems related to Data importation and transformation (ETL). However, some business cases present challenges that are solved faster and better if we are able to make slight amendments to the M Code that Power Query generates for us through the buttons we click in the user interface. We will look at some practical examples of very helpful M code snippets in Power Query in Excel.

________________________________________________________

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
___________________________________________________________________

Chapters:
0:08 – Introduction
01:37 - What is the M language and how to access the code
02:09 - Learning Resources for M Language
03:57 - Example 1: Getting the value of one cell in Power Query (Table, Column, Row, Cell)
12:52 - Example 2: Getting Data from the first day of the current month onwards
19:15 - Example 3: Dynamic Column List
28:13 – Conclusion

For this tutorial T0020 in particular, no exercise files are available. Only a PDF with links for learning resources.

________________________________________________________

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
___________________________________________________________________

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

Twitter: @celia_excel
Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

[garydunken]

Wow, that was great. Subscribed.
I have been using PQ on Excel and gotten into customise the M code. This video was helpful and learnt a few new things, like that editor zoom with Ctrl, Shift+, magical Navigation step, etc.
Thank you.

[andrewsinha]

Hi Celia, 3 great example to get us started ..Removing the fear and releasing the true power of Power Query. Great simple straight forward teaching. Thanks again. Andrew

[GrainneDuggan_Excel]

Just as interesting the second time around. Thanks Célia.

[altemardasilvaevangelista]

Great, I did finish watching .
Now, Let's go to practice

[MPeixe]

Celia, you tips are other's level. Thanks for sharing!

[wayneedmondson]

Thanks Celia. Awesome.. as always! Thumbs up!!

[freebird]

Thanks.. Celia. appreciate your great teaching.. showing the very key points and clearance..😆

[TheMoh]

Many thanks, Celia,

In the 2nd EXP, *Date. Month(DateTime.LocalNow())* work properly without *DateTime.Date()*

Regards.
Mohammed from Algeria.

[MarshaMinus]

Great job Celia. I have some opportunities in my current projects to use these tips. Thank you for sharing!

[jazzista]

Celia. this was a GREAT video. Specially the first transformation example you did by referencing a row and a column from a cell. Thanks. Do you have more powerquery videos that i can watch ? Again, great content.

[muralidharannatarajan]

Thanks a lot for a very clear explanation

[stephenkaras]

Extremely informative. Great detail and nice use of nested functions. Keep up the good work! I look forward to seeing more videos 🥳

[bamakaze]

You need more subs! I will share to help.

[Mahmoudalgindy]

Wow! I am the first viewer
Thanks Celia!

[truelove]

File me upload karte smy errors kiyo aata hai