Writing DAX Queries

Overview

As a DAXdeveloper you've probably written many measures, expressions and code for calculated columns. But, DAXis also a full featured and powerful query language for retrieving data in a table format, much like SQL.

There is much more to being a professional DAXdeveloper than just writing measures.

Syllabus

• Introduction to DAX Queries
Overview of DAX as a Query Language
Comparison with SQL
Use Cases for DAX Queries
• Fundamentals of DAX Query Syntax
Understanding EVALUATE
The CALCULATETABLE Function
Using FILTER, SUMMARIZE, and ADDCOLUMNS
• Working with DAX Functions for Querying
Aggregation Functions in DAX Queries
The Role of Iterator Functions
Time Intelligence in Queries
• Advanced DAX Query Techniques
Querying Complex Data Models
Using Variables in DAX Queries
Implementing Row-Level Security
• Optimizing DAX Queries
Best Practices for Performance Improvement
Understanding Query Plans and Storage Engine
• Practical DAX Query Scenarios
Building Reports with DAX Queries
Real-world Scenarios and Challenges
• Tools and Resources for DAX Developers
DAX Studio for Query Analysis
Power BI and DAX Integration
• Conclusion and Next Steps
Efficient Query Writing Strategies
Expanding into Advanced DAX Topics

---

Taught by

Randy Minder

---

Subjects

Business