Keep / Remove Columns
In this lesson I will show you how and when to use Keep/ remove columns transformations in Power Query.
Custom Columns
In this lesson we talk about what a custom column transformation does and go through some examples.
EX1: Proper Casing and Remove Underscores on headings
In this lesson I go through how to do proper casing and remove underscores on column headers.
Date Values
In this lesson we will go through the M value Date.
Intro to M expressions
In this lesson we will go through the contents of the M expression module
Recursive functions
In this lesson we will go through how to write recursive M functions.
Shared Keyword
In this lesson we will go through what the shared keyword is in the M language.
Split Columns
In this lesson I will show you how and when to split columns in Power Query.
Conditional Column
In this lesson we talk about what a custom column transformation does and go through some examples.
EX2: Group steps
In this lesson I go through how to group steps using M.