Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Courses / M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]

M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]

posted on

Please log in to access your purchased courses.
Please log in to access your purchased courses.

Learn the Fundamentals of the M Language with MVP Ruth Pozuelo Martinez by taking the M Language Online course: The unofficial and practical Reference Guide.

In this course, we will go through the Official M Reference Language Guide but explain it with practical examples and exercises. See the video below for more details.

This course includes:

Who is this course for?

This course is for you that use Power Query in a regular basis and you find yourself working with the Advance Editor more and more.

It you are new to Power Query, I recommend to start with Power Query Online course first.

What are we going to cover?

In this course will will cover the following topics:

  1. Basic Values: The lower level components in M
  2. Advance Values: Tables, Lists and Records
  3. Operations in M: The type of operations you can do between basic and advance values.
  4. M Expressions: How to create simple and complex M expressions
  5. M functions: How to create simple and more complex functions
  6. M Enviroments: Did you know that M has also evaluation contexts? Here we explain what those are and how to navigate them
  7. Custom Connectors in M: We will show the components that make a custom connector and how demo how to create two connectors to get you started.
  8. Quiz: A chance to prove your mastery!

Course outline:

Basic Values

Lessons

Intro to M values Preview Null Values Logical Values Numerical values Time Values Date Values Datetime Values Datetimezone Values Duration Values Text Values Binary Values

Advanced Values

Lessons

Record Values List Values Table Values Extract values from records (Field Access) Preview Extract values from lists (List Access) Extract values from tables (Item Access)

Operations in M

Lessons

Null Operations Time Operations Date Operations Text Operations Operations with Records Operations with Lists Operations with Tables

M Expressions

Lessons

Intro to M expressions Simple Expressions Let Expression Preview M syntax If Expression Error Expression Try Expression

M Functions

Lessons

Intro to M functions Write M functions Nested functions Recursive functions Each Keyword M function library Metadata Document a M function Reuse M functions

M Environments (Evaluation context)

Lessons

Intro to M Environments Simple Environments Access Child variables Access Parent variables Naming variables in different Environments The Global environment Combine Global and Outer environment

Custom Connectors in M

Lessons

Intro to custom connectors Create your first connector Test the connector in Power BI Desktop and Service Shared and Section Keywords Authentication Publish UI Build and Deploy your connector
Final Quiz and Certification