Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


DAX in SQL Server Tutorial, Formulas, Functions and Examples


In this tutorial we are going to learn to create DAX formulas to get desired information from a Tabular Model ranging from getting a simple calculation to solving a slightly complex analytical problem.

We are going to run DAX formulas against a deployed tabular model to find out different type of facts based on different requirements.

This tutorial is primarily focused on the technique to create simple DAX queries and then moving forward to create slightly complex DAX queries step by step.

This tutorial may help a learner to quickly learn DAX provided the learner sticks with the core concepts of making the DAX query and/or formula construct which I am going to discuss.


This tutorial assumes you are familiar with basic concepts of Tabular Data Models (also known as Analysis Services Databases) and have installed the following software components:

  1. Tabular Analysis Server
  2. SQL Server Data Tools (SSDT) or Excel with Power Pivot

Last Update: 12/11/2018

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools