Business Intelligence, Data Warehouse and Data Lake

SQW07 Introduction to Power Query Language M


4:00pm - 5:15pm

Level: Intermediate

Arthur Graus

Power BI Trainer / Consultant

M is the formula language behind Power Query. Every transformation you apply to your data is translated into M code.

Knowledge of this language opens doors that remain closed when you only use the graphical interface.

In this session, you will learn what else is possible by using the Advanced Editor, such as:

  • Working with variables and data types
  • Custom Columns and Time Intelligence Filtering
  • Data grouping and sorting
  • Creating table and scalar functions
  • Crossjoin between 2 tables (make all possible combinations)

You will learn:

  • Syntax of Power Query language M
  • Create custom functions
  • Add Time Intelligence filtering