Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

PowerQuery M-Code - Complete Course (24 hours)

Name: PowerQuery M-Code - Complete Course (24 hours)
Rating: 4.3 (474 reviews)

Learn Power Query M Code with Lists, Records, Functions, Text & Date Functions, Dynamic Solutions and Real-World Project

Created byajay parmar

Last updated 9/2026

English

English [Auto],

What you'll learn

We will learn the use of M functions in PowerQuery . M stands for Mash-up language.
Understand the fundamentals of Power Query M Code and learn how to read and write M syntax
Work with Lists Records Tables and important Table and List functions in Power Query
Create and use IF functions custom functions parameters variables and optional parameters in M Code
You will learn the basics of Mcode. How to write your own syntax.
Use Text Date List and Record functions to solve practical data transformation problems
Write and modify M Code directly to create solutions that go beyond the Power Query user interface
Build dynamic and reusable solutions using advanced List functions including List Generate
Apply M Code to real world data cleaning transformation and automation projects including practical student questions and business scenarios

Course content

8 sections • 77 lectures • 23h 58m 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
Master M code in Power Query: learn let and in structure, handle spaces with hash prefixes, and interpret applied steps as functions producing tables or values.
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
Learn to auto reflect new columns across multiple sheets in Power Query by using M code to build a dynamic header list from table column names.
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
Explore linking values from different rows in Power Query M code by adding an index, creating a custom column, and using step references to multiply and sum across rows.
Table Sort & Table Select Columns-Ready for any scenario9:35
Learn to use Power Query M code to sort data with table sort and to extract specific columns with table select columns, improving data shaping in any scenario.
Amazing Project - How to put headers from high to low values17:51
Learn to restructure data in PowerQuery by unpivoting four category columns, sorting from highest to lowest, and transposing headers to produce a clean, sortable table ready for merging.
SQL Server Query controlled from Excel Cell - Magnificent Project13:46
Learn to import data from a SQL Server into Power Query via Excel cell input, using Adventure Works 2019, with optional where clauses and Excel-driven parameterization.

1. What are we covering- A quick demo4:46
2. Introduction to IF FUNCTIONS7:02
Learn to write if functions in PowerQuery M-Code, using single and multiple conditions with if, then, else, and practice in the add column context versus the advanced editor.
3. IF Functions Part211:08
4. IF Functions Part39:12
5. User-defined Functions - Create own functions - How and Why ?26:42
6. User-defined Functions - Create own functions - How and Why - part217:23
7. User-defined Functions - Part349:03
8. Error handlers27:47
9. A project for you- Top3 Salaries10:25
Use Power Query M-code to find the highest and second highest salaries by merging employee data, sorting salaries descending, and extracting the top two.
10. Super Project for you - Avoid irrelevant rows Example122:09
Learn how to extract invoice data in Power Query by excluding irrelevant rows using table.selectRows, indexing, and dynamic steps; build a reusable approach across multiple sheets.
11. A project for you- How to avoid specific rows - its awesome36:47
Learn to dynamically identify rules in Power Query and split data into two tables: serial numbers and IDs, using list.first and list.last to set start and end rows.
12. Get Percentage of each column field- List functions use in a great Style10:44
Learn to compute each employee's percentage of total sales in Power Query using list.sum and custom columns, and compare contributions to the maximum sale.
13. A project for you- Create Ranking for each of the category - So much learnin8:52
Create per-category rankings in Power Query M code by grouping data, adding an index per category, and producing sequential ranks for liquids, solids, and household items.
14. A project for you- Reverse and get the unique Author Books - Simple awesome15:49
Learn to extract unique author books in reverse order using Power Query M-Code, including unpivoting data, removing duplicates, grouping by author, transposing rows, and final table shaping.
15. CountIF function - So much knowledge7:35
16. SumIF Function - More knowledge coming in your way13:59
17. Table Transform Column function - A boon to data analyst8:24

1. Basic Date functions we must know Extraction and Conversions20:40
2. A quiz on date handling for you. Its fantastic20:42
Learn to calculate month differences between two dates in Power Query M, handle year transitions, and use date year and date month functions in custom columns.
3. Student question is answered with a new solution - more robust11:00
4. Let us start with important Date functions13:05
5. My favorite List Date function25:13
6. How to combine two or more table values using List Union Function12:01
learn how to combine two tables' item values with the List.Union function in Power Query M, and count total items while handling duplicates.
7. How to use List Intersect function - Fundamentals and Example3:54
8. An amazing project for you on List Union Function18:03
Filter two power query tables by start date, then union results with List.Union to create a consolidated items list, and enable dynamic date input via a past date parameter.
9. Know your List Difference function and upskill your talent25:24
Explore the Power Query M code list difference function, comparing two lists to find values absent from the second, with case sensitivity options and multi-table workflows.
10. Your Question solved6:09
PowerQuery M-Code shows how to calculate the day difference between a start and end date and generate that many rows using the list.date function, expanding data for each date.
11. Calculate cumulative totals using List Sum and List Range functions14:00

13. How to use Left function TextStart in Powerquery14:25
14. How to use Right Function TextEnd4:37
15. How to use MID and FIND Functions in M code15:17
16. How to find if a value contains specific string and how to reverse the strin9:12
17. How to add a value and remove a value from a string or table16:25
18. Your question on Removing more than one value in any string. A great Learnin8:10
Create a separate list and use a Power Query function with text.remove to delete multiple items, starting at zero, like dollar and star.
19. One more practical example for you on TEXT Functions. If you can do it12:38
20. 7 short but very useful TEXT Functions15:39
21. Student question solved - How to split year and status24:43
22. One more project - Your question my solution- Find Last record of duplicate10:00
Group data by employee id and use table.last to extract the last row for each duplicate group. Clean and convert dates to proper date values.

1. Introducing List Generate function11:24
Explore the Power Query M list.generate function, learning how initial, condition, and next function parameters create loops to produce sequences, with examples from 1 to 10 and stepwise increments.
2. Another example on List Generate1:53
3. How to use Variables in List Generate10:58
4. Use more than two variables in function13:12
Learn to implement list.generate with three inputs x, y, and z and an optional fourth parameter, incrementing each step while x plus y stays under 50 in PowerQuery M.
5. Secret is out - Optional parameter in list generate - no one knows11:47
6. Find Replace Project for you15:04
7. Behind the Scenes - Know everything- fundamentals43:37
8. Replace all values22:41
9. Convert code into a function16:18
Convert a Power Query code into a reusable function, define parameters, and dynamically apply replacements by invoking the function with new inputs from a table.
10. Finishing the Task12:09
11. Issues not to be ignored11:52
Explore common issues in Power Query M code when replacing words, ensuring whole-word matches with careful use of spaces, and using Excel techniques and proper case to avoid unintended replacements.
12. Table Sort function - A project for you7:04
13. Project continues7:06
14. Table Select function7:10
15. How to Join pair of table fields - Use Mcode instead its ribbon menu21:21
Learn how to join pairs of table fields in Power Query using M code, via text.combine with a separator, and handle numeric fields with text form when needed.
16. Using Function - My favorite approach16:35

17. What is the task here1:57
18. Creating lists using list zip and table to columns functions9:45
Master converting table to column data into lists using the table to column function, then pair and concatenate elements with list zip to build indexed results.
19. Looping begins - List Generate39:03
Learn to create a custom column with list generate in PowerQuery M, converting a list to a table and using text.combine in the advanced editor to concatenate paired values.
20. Making the code dynamic for a robust solution24:34
Develop dynamic Power Query solutions by extracting values, transforming tables to lists, creating columns with table from columns, and aligning rows via indices.

Requirements

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

Description

Section One

Introduction to M Code

Introduction to M Code Language

Understanding Power Query M Code

Editing M Code Directly

Understanding Power Query Steps

Table Functions Introduction

Introduction to Lists

Working With Lists

Practical List Examples

Using Lists To Create Dynamic Solutions

Working With Records

Record Objects And Practical Examples

Using Lists And Records Together

Section Two

Intermediate M Code

Introduction To IF Functions

IF Functions Part Two

IF Functions Part Three

User Defined Functions

Creating Your Own Functions

Function Parameters

Using Multiple Variables In Functions

Optional Parameters

Error Handling

Top Salaries Project

Avoiding Irrelevant Rows

Avoiding Specific Rows

Percentage Calculations

Category Based Ranking

Finding Unique Records

CountIF And SumIF Concepts

Table Transform Column Function

Section Three

Date And List Functions

Basic Date Functions

Date Extraction And Conversion

Date Handling Quiz

Practical Date Problem Solving

Important Date Functions

List Union Function

List Intersect Function

List Difference Function

List Sum And List Range Functions

Linking Data With Excel Cells

Practical List Projects

Section Four

Text Functions

Text Start Function

Text End Function

Text Middle Function

Text Position Of Function

Finding Specific Text

Checking Whether Text Contains A Specific Value

Reversing Text

Adding Values To Text

Removing Values From Text

Removing Multiple Values From Text

Splitting Text

Practical Text Function Projects

Finding Duplicate Records

Finding The Last Record Of A Duplicate

Section Five

Advanced Text Functions And Practical Projects

Advanced Text Transformations

Practical Student Questions

Dynamic Text Solutions

Finding And Replacing Values

Replacing Multiple Values

Creating Robust Text Solutions

Real World Data Transformation Projects

Section Six

Projects And Real World Applications

Finding Top Sales

Finding Rankings By Category

Removing Irrelevant Rows

Avoiding Specific Rows

Finding Unique Records

Reversing And Extracting Data

Finding Duplicate Records

Finding The Last Record Of A Duplicate

Controlling SQL Server Queries From Excel Cells

Dynamic Column Handling

Working With Changing Headers

Section Seven

Advanced List Functions

List Generate Function

Creating Dynamic Lists

Using Variables With List Generate

Using Multiple Variables

Optional Parameters In List Generate

Find And Replace Project

Replacing All Values

Converting Code Into A Function

Table Sort Function

Table Select Columns Function

Table Join Function

List Zip Function

Table To Columns Function

Looping With List Generate

Creating Dynamic And Robust M Code Solutions

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.

PowerQuery M-Code - Complete Course (24 hours)

What you'll learn

Explore related topics

Course content

Introduction to Mcode17 lectures • 7hr 37min

Intermediate Level17 lectures • 4hr 48min

Date and List Functions Use11 lectures • 2hr 50min

An advance Project Using FUNCTION1 lecture • 1hr 15min

TEXT FUNCTIONS10 lectures • 2hr 11min

Projects - Your questions1 lecture • 12min

List functions - Advance16 lectures • 3hr 50min

Project using List Generate - Concatenate the columns pair4 lectures • 1hr 15min

Requirements

Description

Who this course is for: