36 - Overview of M Formula Language in Power Query

In this video, I will give you an overview of the M formula language in Power Query. This is the language that powers the Power Query engine. The M in M Formula language comes from Mashup (as in Data Mashup) I will show you the overall construct of the M language and how to read the code ✅ Power Query Course Download files: https://trumpexcel.com/course-download-files/ ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 ------------------------------------------------------------------------------ 0:00 Introduction to M Language in Power Query 0:49 Opening Sample Data in Power Query 1:43 Accessing the Advanced Editor to View M Code 2:31 Understanding the Basic M Code Structure 3:43 How Code Changes When Steps Are Added 5:15 Rules for Commas in M Code 6:14 Working with Multi-Word Step Names 7:59 Adding a Calculated Column 9:55 The "each" Keyword Explained 10:14 Using Line Breaks to Make Code Readable ------------------------------------------------------------------------------ #Excel #PowerQuery #ExcelTips