DAX for the SQL developer

2019

TL; DR

Learning DAX can be tricky, especially if you have a background in SQL.

Session Details

"Learn DAX", they said. "It'll be easy with your background", they said. Well, it turns out that it wasn't. Transitioning from SQL to DAX gave me nightmares and ulcers, and this session is for everyone who is looking over the edge and considering undertaking the challenge. It is in no way impossible, only frustrating, as DAX has a very different approach to data from what a SQL programmer is used to. In this introduction to the DAX language, I'll be putting a somewhat different spin on DAX from a beginners' standpoint. I'll be going over the basic mental mistakes that many people trying to learn DAX do, how to solve them and how to put your brain on the right track!

3 things you'll get out of this session

Alexander Arvidsson's other proposed sessions for 2026

Turning insights into action: The art of data communication - 2026

AI Makes You Faster(?) - What LLMs Actually Are and Why It Matters - 2026

Fabric FinOps - Cost Optimization for Fabric - 2026

Fabric in Perspective - Interfacing Fabric With the World Beyond - 2026

From SQL to Spark and Back Again - Spark and Python for SQL Users - 2026

Invisible Insights: What Your Data Can't Tell You - 2026

Knee-Deep In Tech Live @ SQL Bits - 2026

No-Nonsense Business Data Modeling for Everyone - 2026

Undoing the Pretzel - Five Tips for Improving Your Body Language - 2026

Alexander Arvidsson's previous sessions

Roche's Maxim of Data Transformation - By Example

Roche's Maxim of Data Transformation states that "data should be transformed as far upstream as possible, and as far downstream as necessary". Simple, powerful, and beautiful - but what does it really MEAN? Come find out through example.

Stand Fast - How Governance Can Save You a Fortune

Why is it that cloud projects often end up way more expensive than they should? The answer might surprise you: a lack of governance. Come learn how to turn governance from limitation to enablement.

Knee-Deep In Tech Live @ SQL Bits

Come be a part of the audience for a recording of an episode of Knee-Deep in Tech, a bi-weekly technology podcast! The topic for this year's recording is: Agile, DevOps; DataOps and all the other methods - help or hindrance?

The Untruthful Art - Five Ways of Misrepresenting Data

In this age of information it is imperative to be able to be able to clearly, simply and accurately explain and communicate sometimes complex data.

+5 Wisdom - Learn to Ask Better Questions to Solve the Right Problems

By asking the right questions we can solve the actual problem - not only the problem we think we are facing. Take a step back, look further, and ask better questions. We'll show you how.

Spell of Transmutation - Using Debezium to Transfer Realtime Data Changes to Event Hub

Getting changes from SQL Server to Event Hub can be tedious. I'll show you how to set up Debezium to automate SQL Server change data capture into Event Hub and explain why this matters for your serverless architecture!

Knee-Deep In Tech Live @ SQL Bits

Be part of a live audience recording of an episode of Knee-Deep in Tech!

Learning to Listen - Making the Most of Mentoring

Being a mentor or a mentee offer amazing opportunities but come with their own sets of challenges. We'll help you make the most of mentoring!