M Language Online Course: The unofficial and Practical Reference Guide
0 of 60 lessons complete (0%)
Exit Course
Basic Values
Intro to M values
Null Values
Logical Values
Numerical values
Time Values
Date Values
Datetimezone Values
Duration Values
Text Values
Binary Values
10 lessons
Advanced Values
Table Values
List Values
Record Values
Nested Values
Extract values from records (Field Access)
Preview
Extract values from lists (List Access)
Extract values from tables (Item Access)
7 lessons
Operations in M
Time Operations
Date Operations
Datetimezone Operations
Text Operations
Operations with Records
Operations with Lists
Operations with Tables
7 lessons
M Expressions
Intro to M expressions
Simple Expressions
M syntax
Let Expression
Preview
If Expression
Error Expression
Try Expression
Example (function, error and try)
Each Keyword
9 lessons
M Functions
Intro to M functions
Write M functions
Invoke M functions
Parameters for M functions
Nested functions
Recursive functions
Invoke a function with Each and Try
M function library
Metadata
Document a M function
Reuse M functions
11 lessons
M Environments (Evaluation context)
Intro to M Environments
Simple Environments
Access Child variables
Access Parent variables
Naming variables in different Environments
Environments in Functions
6 lessons
Custom Connectors in M
Intro to custom connectors
Custom connectors Workflow
Section Keyword
Preview
Shared Keyword
Authentication
Publish UI
Schedule refresh in Power BI Service
Create your first custom connector
Create a generic OData custom connector
9 lessons
Final Quiz and Certification
Advanced Values
Table Values
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.
Purchase course
Sign in
In this lesson we will go through the M value Table.
To access this content, you must purchase
M Language Online course: The unofficial and practical Reference Guide
or
M Language + Power Query Course Bundle
.
Previous
Next