Overview
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.
Prerequisites
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:
- Tabular Analysis Server
- SQL Server Data Tools (SSDT) or Excel with Power Pivot
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
