M Language Tips to achieve more with Power Query – T0020

Опубликовано: 22 Февраль 2025
на канале: Celia Alves - Solve & Excel

11,973

485

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.

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

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

Join my Telegram Group at https://t.me/celiaalvessolveexcel to access exercise files and other content.
For this tutorial T0020 in particular, no exercise files are available. Only a PDF with links for learning resources.

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

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

Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves
Facebook:   / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//   / celiaalvessolveexcel

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