Understanding Numeric Calculations in DAX
DAX (Dynamic Analysis Expressions) is a formula language to enrich imported data with calculated columns, calculated tables and measures in Excel's Data Model, in Power BI, and in Analysis Services Tabular. 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.
first experience in Excel Power Pivot, Power BI and/or Analysis Services Tabular is helpful