SQL Friday #5: Markus Ehrenmüller-Jensen on “Introduction to Numeric Calculations in DAX”
|How to attend:||Already finished|
|Accompanying material:||Download from here|
Introduction to Numeric Calculations in DAX
DAX (Dynamic Analysis Expressions) is a formula language to enrich imported data with calculated columns, calculated tables and measures in Power BI, Excel and Analysis Services. While the syntax of the language is derived from Excel’s formula language and easy to learn, some of the functions are hiding a complex semantic.
This talk starts on a zero DAX knowledge level but will introduce advanced concepts. We will concentrate solely on numeric calculations. You will learn the difference between calculated columns and measures and between row context and filter context. We will discuss how CALCULATE operates.
Markus will gently walk you through different examples of increasing complexity which will pick your brain – don’t forget to bring your favorite hot beverage to stay focused during this 60min!
Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, trainer & consultant for data engineering, business intelligence, and data science since 1994.
He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform, MCSE Business Intelligence, and MCT.
Markus speaks regularly on international conferences (eg. PASS Summit, SQLBits, SQL Saturdays, SQL Days, Power BI World Tour, …) and writes articles for well-known journals.
In 2013 he co-founded SQL PASS Austria and in 2015 Austria PUG and organizes SQL Saturdays in Austria since 2014. For his technical leadership in the community he was awarded as a Microsoft Data Platform MVP since 2017.