Writing DAX Queries

Writing DAX Queries

Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models. The goal of this course is to teach you what a complete DAX query is and how to read and write one. You'll learn how a query is constructed, the tools available to execute your queries, exporting data, and all the various DAX table functions available to help you.

Course Goal

  • Understand the tools available to write full DAX queries
  • Learn how to construct a DAX query
  • Review how to export the results of your DAX queries to CSV and SQL Server
  • Learn how to write common T-SQL queries as DAX queries
  • Understand the difference between a DAX measure and a full DAX query

Who This Training Is For

  • Developers


  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Writing DAX Queries certificate


Randy Minder

5.0 Average Rating

3 Reviews

19 Students

3 Courses

Randy Minder

Siesta Key Software, LLC - Founder

Microsoft Certified Professional: Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019) Seasoned database architect (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence, and Power BI. I have 20 years of software development experience using a variety of Microsoft technologies, mostly C#. I was a 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure. StackOverflow reputation of 40,200 (top 1%).

Student Feedback


Average Rating


Language: English
Level: Intermediate
Duration: 3.5 hours
Type:  Instructor-led
Category: Technology

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business