• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Curbal

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

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
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 November 6, 2018

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:

  • 54 video lessons
  • around 3 hours of short videos
  • Downloadable resources
  • Lifetime access
  • Certification upon course completion
  • Mobile Friendly
  • Access to the Power BI High level introduction course included
  • 3 preview lessons available

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

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel (+130k subs)!

Apply for Membership (+50,000 members)

Become a Member

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In