Advanced Concepts

This video introduces you to the techniques you will be learning as part of this Advanced Concepts module.

In this lesson, you will formally get introduced to the M language, which is the formula language used in Power Query.

In this lesson, you will revise one of the advanced concepts that I taught you as a part of the lesson Appending Multiple Tabs, in more detail. The concept is that of referencing a column or a row using relative reference as against the usual absolute reference.

In this lesson, you will learn how to create an M function manually.

In this lesson, you will learn how to use the Combine & Edit feature of Power Query that is available in the later versions, to create an M function automatically for you.

In this lesson, you will learn how to perform a Cross Join on two tables.

In this lesson, you will learn how to create a nested index column in Power Query.

In this lesson, you will learn how to handle errors in Power Query, using the keywords Try and Otherwise. You will also revise the usage of #Shared.