Learning DAX in Easy Steps

Name: Learning DAX in Easy Steps
Rating: 4.6 (188 reviews)

Best of Data Analysis Expressions (DAX) for Beginners in 90 mins. Especially created for those who gave up learning DAX.

Created byYoda Learning

Last updated 5/2020

English

What you'll learn

Essential DAX Concepts
Powerful DAX Functions
Creating Data Models
Developing DAX Formulas in Microsoft Power BI
Calculated FIELDS and MEASURES using DAX

Course content

4 sections • 23 lectures • 1h 25m total length

Learning Path + Downloadable Course Files3:02
In this video, we will see the learning path and some important tips that are required to learn DAX. Also, you can download the practice files for this course from here.

DISTINCTCOUNT2:29
In this video, we will learn about the DISTINCTCOUNT function. It counts the number of distinct values in a column.
Syntax: DISTINCTCOUNT(Sales[CustomerKey])
COUNTROWS1:26
In this video, we will learn about COUNTROWS function. It counts the number of rows in the specified table
Syntax: COUNTROWS(Sales)
Understanding Column vs. Measure using SUMX (Iterator)4:38
In this video, we will learn about SUMX function. We will also learn about the difference between the Column and Measure using SUMX function.
Why SUM Measure?2:44
In this video, we will see the importance of creating a measure for a simple thing as SUM
CALCULATE2:23
In this video, we will learn about one of the most important DAX function: CALCULATE
Syntax: CALCULATE(<expression>,<filter1>,<filter2>…)
FILTER3:11
In this video, we will learn about the FILTER function. This function gets a table and returns a table that has the same columns as in the original table.
Syntax: FILTER(<table>,<filter>)
Unique Date Table using CALENDARAUTO3:18
In this video, we will learn to create a Unique Date Table using CALENDAR function
Syntax: CALENDAR(<start_date>, <end_date>)
DATEADD5:44
In this video, we will see the Month on Month (MoM) and Year on Year (YoY) comparisons using the DATEADD function.
SAMEPERIODLASTYEAR3:18
In this video, we will learn about SAMEPERIODLASTYEAR function
Syntax: SAMEPERIODLASTYEAR(<dates>)
DATESINPERIOD6:29
In this video, we will learn about DATESINPERIOD function
Syntax: DATESINPERIOD (<dates>, <start_date>, <number_of_intervals>, <interval>)
TOTALYTD4:11
In this video, we will learn about TOTALYTD function of DAX. Here YTD stands for Year to Date.
Syntax: TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>])
ALL, ALLSELECTED8:05
In this video, we will learn about ALL and ALLSELECTED DAX functions
Syntax:
ALL( [<table> | <column>[, <column>[, <column>[,…]]]] )
ALLSELECTED([<tableName> | <columnName>[, <columnName>[, <columnName>[,…]]]] )
DIVIDE3:40
In this video, we will learn about DIVIDE function
Syntax: DIVIDE(<numerator>, <denominator> [,<alternateresult>])
RELATED3:30
In this video, we will learn about RELATED function of DAX. It is very similar to Vlookup or Index formulas in EXCEL.
Syntax: RELATED(<columns>)
SUMMARIZE6:00
In this video, we will learn about SUMMARIZE function.
Syntax: SUMMARIZE(<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, <name>, <expression>]…)
ADDCOLUMNS2:05
In this video, we will learn about ADDCOLUMS function in DAX. It helps to add columns as the name suggests.
Syntax: ADDCOLUMNS(<table>, <name>, <expression>[, <name>, <expression>]…)
DISTINCT2:25
In this video, we will learn about DISTINCT function (Meaning Remove Duplicates)
Syntax:
DISTINCT (column) – values
DISTINCT (<table>) – duplicate rows
FORMAT1:36
In this video, we will learn about FORMAT function of DAX. It is very similar to TEXT of Excel

Requirements

Creating Formulas in Microsoft Excel
Fundamental Concepts of Calculated Fields
Power Pivot in Excel Basic Reporting

Description

Data Analysis Expressions (DAX) is the formula language of Power BI, Power Pivot, and SSAS (Tabular models). DAX is a functional language (executed code is contained inside a function). Learning DAX is much like discovering how to use formulas in Excel.

This course covers all the essentials functions/parameters that make DAX unique.

If you are learning DAX from scratch or already know the basics, this course will help you all to master the Power BI.

We'll first get started by learning the essential terms in DAX such as:

Implicit and Explicit Measure
Calculated fields
Evaluation Context
Table Relationship
Table Types and more

Next, we'll see DAX functions in action like, DISTINCTCOUNT, COUNTROWS, CALCULATE, DATESBETWEEN, DISTINCT, and more.

By the end of this course, you'll have the knowledge of:

How the DAX engine works
Using DAX to model and analyze your data
How to aggregate and filter with ease

The course is structured to minimize theory and focus more on action. The quick wins will keep you motivated to deep dive further

Who this course is for:

Users who want to start their DAX learning journey
Users who have tried to learn DAX multiple times but left the journey early on owing to the complexity
Readers who depend heavily on MS Excel for charts, tables, and reports
Anyone who use MS Excel regularly to analyze data
Professionals who use data modeling and data analysis for reporting and decision-making

Learning DAX in Easy Steps

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Essential Terms - Part 13 lectures • 9min

Essential Terms - Part 21 lecture • 6min

DAX in Action18 lectures • 1hr 7min

Requirements

Description

Who this course is for: