SQL Friday #5: Markus Ehrenmüller-Jensen on “Introduction to Numeric Calculations in DAX”

Online Microsoft Data Platform Lunch Sessions

SQL Friday #5: Markus Ehrenmüller-Jensen on “Introduction to Numeric Calculations in DAX”

2020-06-09 Past SQL Friday Sessions 0
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download from here
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

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!

About Markus

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.