Constructing DAX syntax
Every language you come across will have a syntax and a structure. Syntax refers to all the elements that you use to construct a formula. A formula usually consists of functions. In Chapter 9, Working with M, in the Understanding the M syntax and writing with M section, you learned all about the M syntax. In this topic, you will learn about the DAX table and column name syntax.
It is important to note, especially if you are only just beginning to learn about DAX, that it is broken up into two parts:
You need to understand these tools as you will need to use the correct tool for the DAX code you are using. Often, we search for reference code and copy the code to adapt to our scenarios, so be mindful of this as you will most likely end up with an error and waste time trying to find out why the code does not work.
DAX functions and Excel functions are much the same in terms of behavior...