What is DAX?

  • DAX - also know as Data Analysis Expressions, is the formula language of Power BI.
  • Learning how to write DAX formulas will open the untapped analytical capabilities of Power BI.
  • You'd be able to perform far more sophisticated analysis as compared to creating 'drag and drop' charts.


Who is this course for?

  • Data Analysts / MIS Professionals
  • Professionals working heavily with Excel for creating reports.
  • Professionals who want to go beyond the simple drag and drop charts in Power BI.


When I started learning DAX, I spent hours trying to find step-by-step, jargon-free instructions to explain the peculiarities of the DAX language. I found none!

It took me a long time and many trials and errors to learn DAX. In fact, I am still learning but I have come a long way.

I'd like to help you in your DAX journey and make it easy, logical and definitely more fun for you to learn DAX.

  • I created this really practical course where-in I teach DAX right from scratch.
  • Assuming that you know nothing about it and you are an Excel user.


The course is split into three parts.

  • Part 1 - DAX Fundamentals  - Core concepts that you need to learn about DAX.
  • Part 2 - Practical Applications of DAX - Solving real-life problems using DAX.
  • Part 3 - DAX Functions Library - A video guide to the most important functions in DAX.


What is not covered in this course...

Visualizations are NOT part of this online course. This course is solely focused on DAX and its core concepts + its practical applications to solve real-life business problems.


After the course, you'll be able to

  • Clearly understand how DAX works.
  • Create, edit and debug simple to complex DAX calculations.
  • Acquire an in-demand skill to tap into the hidden analytical power of Power BI.

Course curriculum

  • 1

    Introduction

    • Introduction

    • Download the Practise Files

  • 2

    DAX Fundamentals

    • What is DAX?

    • Take a Shot at Solving these Questions

    • Answers

    • Implicit Calculations - What does this Mean?

    • Explicit Calculations - What does this Mean?

    • Filter Context - How DAX Measures Work

    • Power BI Relationships - Far Easier to Manage than the Real Ones

    • Iterator Calculations - Do it Row by Row

    • Row Context and Context Transition

    • Setting up a Calendar Table - Calendar Year or Fiscal Year? Part 1

    • Setting up a Calendar Table - Calendar Year or Fiscal Year? Part 2

    • Customising the Calendar Table to Accommodate Fiscal Year

    • Show me YTD / QTD / MTD

    • DAX Best Practises

    • How much is the Growth?

    • This Doesn't Seem Right - Adjust the Period

    • How to Use DAX in Power Pivot

    • Active / Inactive Relationships

    • How to Learn DAX

    • Not in a Relationship - Disconnected Tables

  • 3

    Practical Applications of DAX - Short Cases

    • Contribution of Analysis - % of Total

    • Actual v/s Budget Analysis

    • Top Selling Product Analysis - Part 1

    • Top Selling Product Analysis - Part 2

    • Top Selling Product Analysis - Part 3

    • Top Selling Product Analysis - Part 4

    • Least Selling Product Analysis

    • Segmentation Analysis - Analysing Data in Class Intervals

  • 4

    DAX Functions Library

    • Column Functions - SUM, COUNT, DISTINCTCOUNT ...

    • SWITCH

    • CALCULATE

    • ADDCOLUMNS

    • FILTER

    • IF, AND, OR

    • SUMMARIZE

    • TOPN

    • CALENDAR and CALENDARAUTO

    • CALCULATETABLE

    • DATATABLE

    • GENERATESERIES

    • RANKX

    • SELECTEDVALUE

    • TOTALYTD, QTD, MTD

    • ALL, ALLEXCEPT and REMOVEFILTERS

    • ALLSELECTED

    • EARLIER

    • COUNTROWS

    • UNION

    • USERELATIONSHIP

    • LOOKUPVALUE

    • HASONEVALUE

    • SAMEPERIODLASTYEAR

Your Instructor

Chandeep is an Excel & Power BI trainer, consultant and blogger. He is the founder of the Goodly blog and YouTube channel.

He lives in Dubai, UAE and used to work as a Financial Analyst for an Investment Bank in Mumbai (India). Back in December 2013, he quit to start Goodly.

Being an Analyst, he became really good with Excel and now teaches Excel and Power BI around the world through online courses, Blog, YouTube and live corporate training programs.