Chapter 9: Working with M
In this chapter, we will be introduced to the Power Query M language and how to use and write the syntax, including the steps to reveal a list of functions and definitions.
This chapter will look at the structure and syntax of M. All programming languages have their own specific syntax and structure, and once you master the structure of M, it becomes easier to understand. We will look at the main data types and functions and provide a walk-through demonstration of how to use each of these data types. Some of the text data types that we will cover include numeric data types, lists, records, tables, searches, and shares, before looking at how to import a .csv
file using M.
In this chapter, we will cover the following main topics:
- The beginnings of M
- Understanding the M syntax and learning how to write M
- Using
#shared
to return library functions, including function definitions, without having an internet connection or connecting to an...