Summary
This chapter provided us with an introduction to how M is used. You have now acquired the necessary knowledge to understand how the syntax is used, and you should be able to look at some code and work out how it works. It makes life a great deal easier when you can look at code and determine what it is doing, especially if there is a problem that you need to solve.
In this chapter, we covered how M came about and how it works, and how it is a functional language that has its own structure and syntax. We made a quick comparison between M, DAX, and VBA with regard to structure and syntax, before looking at how to write M code. Although we have mostly used the Advanced Editor window in the Power Query editor, using the same code, we could type it into the formula bar; however, it is better to use the editor, as once your code goes over multiple lines, it is not always easy to spot a mistake in the formula bar.
This chapter included many working examples, going through text...