Introduction to Numeric Calculations in DAX

DAX (Dynamic Analytic Expressions) is a formula language to enrich imported data with calculated columns, calculated tables and measures. While the syntax of the language is derived from Excel’s formula language and easy to learn, some of the functions are hiding a real complex semantic. In this talk we will concentrate on numeric calculated columns and measures. You will learn about the differences and advantages of each. You will leave this talk with the knowledge, how to distinguish filter contexts and row contexts and in which cases to use calculated columns and in which cases to use measures.