When learning DAX you will soon discover, that it is both, “easy, but hard” (© Alberto Ferrari). On the one hand, the syntax of this language is very close to Excel formulas and easy to understand. On the other hand, the semantic of some functions is very challenging. In this talk Markus will share the challenges he faced when learning the language and how overcame them. You will get a proper understanding of the differences between calculated columns and measures and you will learn of the concept of context and how to manipulate the context to achieve advanced calculations.