PowerQuery M Code Programming - Part 1 (7 hours)

Name: PowerQuery M Code Programming - Part 1 (7 hours)
Rating: 4.4 (469 reviews)

Powerquery M code, Powerquery M functions, How to use M code

Created byajay parmar

Last updated 2/2025

English

What you'll learn

We will learn the use of M functions in PowerQuery . M stands for Mash-up language.
You will go beyond front interface and see how we can change powerquery codes the way we want and control the data and shape it up in much better way.
Front End is powerful but it cannot match with the Back end abilities when it comes to data cleaning and structuring .
Practical use of M functions - Table functions, List functions, use of records . Many amazing projects as well.
You will learn the basics of Mcode. How to write your own syntax.
Rules to follow while writing syntax. How to customize it, How to take inbuilt syntax and change it .
What are lists , records and Table . Also, use of Table functions, List functions etc
M langue or M code will make you awesome from every angle in controlling and cleaning the data and then finally helps in analysis.
Its a course for those professionals who want to begin with M code and they are aware of Powerquery

Course content

1 section • 17 lectures • 7h 36m total length

Introduction to Mash Up - M code43:59
What is M code language in powerquery
Where it is written and how we can do changes if result demands it
Rules to follow in writing M code language
By default Syntax formation - How you can change it
Taking help of Default syntaxes and doing amazing things
How to rename steps
Theory PQ editor follows when you do data changes or applies steps
What are the applied steps and what do they do actually.
Use of punctuation - Need and Importance
Write your own steps in blank query - For better understanding and confidence
Know more about M code language16:33
Edit the PQ directly without adding new steps -More necessary information.15:57
What if instead adding new steps or deleting existing steps because of some last minute modifications you can just directly jump into PQ editor and modify the code. That will be awesome
Unleashing the power of M code in this lecture. More information means more visibility in terms of what are we going to do in upcoming sessions with this amazing M code.
Table Functions Introduction42:18
Learn the use of M Table functions and see the outcomes. it has no comparison with normal powerquery.
Using table functions - in real situations and talking about them from scratch
Amazing List Introductions - Why and how we use them1:13:07
What is List object in PQ.
How it is different from table functions.
How to use List functions and Why we need it
Complete tutorial on Lists objects or Functions with real time examples
Surprise Test for you on List - Can you do it?25:33
Just want you to understand the question and do it by yourself. Of-course, later come back and see the solution. Its a revision as well as a kind of quiz for you.
Test1
Test2
Test3
Test4
Test5
Test6
Auto Reflect New Columns using List knowledge25:30
Time to see magical Record objects25:25
What are the records in PQ. Their syntax formation and Use in practical life.
Linking excel cell with PowerQuery - In following record chapter you shall see
Calculation the performance gap between current and previous month using Index and Record combination. Simple Awesome!
Example of Record in practical life19:05
How about linking excel cell with powerquery output. This is possible and it is possible because we have learnt now how to use record objects in PQ.
Second real example of using Records16:02
How to do comparison between current and previous values in table. A wonderful example to showcase the talent of record object in PowerQuery
Project for you - Authors Book alignment Challenge7:41
Tough Project Challenge for us - Headers are different1:05:12
Student discussed the issue that he was not able to compile files which are very big in numbers because of the different headers showing in each workbook. So, before we compile all those files into one, we need to go and make sure each file has same header naming convention.
PQ ribbon first and then use it in M code -Smart way of Writing IFs - PRACTICAL15:40
I would like to give your more confidence here. A clear Vision with creative ideas must be shared with you which can help you in doing the things by yourself. Such examples will help you.
How to link values from different rows Your Question my solution23:43
Table Sort & Table Select Columns-Ready for any scenario9:35
Amazing Project - How to put headers from high to low values17:51
SQL Server Query controlled from Excel Cell - Magnificent Project13:46

Requirements

You should be knowing Powerquery basics . You should know how to work with powerquery features available in its Ribbon.

Description

This course PART1 is an attempt to make you awesome in using M code in PowerQuery
Course is built on a slow pace so newbies can understand the fundamentals on which M code is built.
I am giving you my live online classes recordings so you will get the real feel of a class. Serious learning with focusing on every part of a mcode.
It is for those students who are familiar with PowerQuery front part .
What is M code in PowerQuery and how do write our own codes plus how do we edit the pq built codes.
How to use Table, List functions in Mcode
How to change or modify M code in PowerQuery by first recording the steps for fast results
What are Table functions and their basics plus real use in life. Table sort, table transpose, table to list, table select columns are the functions discussed
What are the list objects - from basic to advance use
What the records - From basics to advance
How to link values in a powerquery like in excel we do. Clear explanation on how things work in Powerquery.
Several mixed projects for your revision at the end plus more knowledge on M functions
This course will make you fundamentally awesome in PowerQuery M code and you can go beyond normal user capabilities to change and modify the data. the way you want.
Files are downloadable and Online help is available from me, in case you have doubts.

Who this course is for:

Students who want to go in data analytics or professionals who want to make career in Excel based applications or who are already working in MIS reporting or business analyst and work day and night in excel.