Power BI DAX Essentials: Basic DAX Formulas and Functions

Focused View

Grant Gamble

4:05:09

84 View

1. Introduction

1. 0101-Welcome to the Course.mp4

02:25

2.1 dax-Introduction.zip

2. 0102-Downloading the Course Files.html

3. 0103-DAX Overview.mp4

04:44

4. 0104-DAX Objects.mp4

09:26

5. 05-DAX Syntax and the Formula Bar.mp4

12:58

6. 0106-Calculated vs Computed Columns.mp4

07:57

7. 0107-Calculated Columns and Visuals.mp4

06:55

2. 02-Calculated Columns

1. 0201-RELATED Function.mp4

06:44

2. 0202-RELATED VS LOOKUPVALUE.mp4

04:08

3. 0203-RELATEDTABLE Function.mp4

05:29

3. 03-Conditional Statements

1. 0301-Nested IFs.mp4

07:59

2. 0302-AND Operator.mp4

05:57

3. 0303-Conditional Concatenation.mp4

08:04

4. 0304-OR Operator.mp4

04:26

5. 0305-IN Statement.mp4

07:28

6. 0306-SWITCH Function.mp4

10:01

4. 04-Calculated Tables

1. 0401-Cloning a Table.mp4

04:09

2. 0402-ADDCOLUMNS.mp4

10:02

3. 0403-FILTER.mp4

06:26

5. 05-Measures

1. 0501-Implicit Measures.mp4

06:52

2. 0502-Aggregating Columns.mp4

03:41

3. 0503-COUNT Function Variations.mp4

13:07

6. 06-Iterator Functions

1. 0601-The SUMX Function.mp4

11:16

2. 0602-The AVERAGEX Function.mp4

12:07

3. 0603-The MAXX Function.mp4

07:46

4. 0604-The MINX Function.mp4

03:40

7. 07-CALCULATE Function Basics

1. 0701-Basic Filter.mp4

10:09

2. 0702-ALL and REMOVEFILTERS.mp4

05:31

3. 0703-Percent of Total.mp4

03:51

4. 0704-Percent of Selected.mp4

09:39

5. 0705-Calculate Outcomes.mp4

06:49

6. 0706-CONTAINSSTRING.mp4

04:10

8. 08-Common DAX Errors

1. 0801-Example 1.mp4

05:06

2. 0802-Example 2.mp4

04:27

3. 0803-Example 3.mp4

03:30

4. 0804-Example 4.mp4

04:32

5. 0805-Example 5.mp4

03:38

Description

Get comfortable and confident in using DAX in Power BI

What You'll Learn?

Increase your confidence with Power BI by learning DAX
Master essential DAX functions
Learn how to avoid common DAX errors
Increase your Power BI efficiency

Who is this for?

Power BI beginners who are struggling to master the DAX language

More details

Description
Power BI DAX Essentials is the first of three courses by G Com Solutions dedicated to the DAX language. And to go along with it, we have DAX intermediate and DAX Advanced.
In this Power BI DAX Essentials course, we will focus on giving you a good grounding in the DAX language, and making sure that you are confident with all of the basics.
We'll discuss the three objects which DAX is capable of creating: calculated columns, calculated tables, and calculated measures.
You'll learn how to write your DAX in such a way that you are far less likely to make errors. You'll learn how to use the formula bar in the most effective manner, how to add comments to your DAX measures, how to use auto-complete effectively to minimize the errors that you make; and the course even contains a section dedicated to discussing the most common errors that people make and how you can avoid making them.
This is very much a hands-on course, and you'll get plenty of real-world practice in writing DAX, and learning to structure your DAX in such a way that you start with basic measures, which then become the building blocks to your more advanced measures.
You'll learn when to use DAX calculated columns in preference to Power Query computed columns, and also the circumstances when calculated columns should be used in preference to measures. But since measures are the most important DAX calculation, most of the course will be dedicated to discussing the creation of measures: some of the key functions that you'll need to use and the technique of nesting functions, whereby one function becomes the argument of another.
You will master iterator functions, which enable you to aggregate a virtual column, saving you the overhead of having to physically add a column to the data model. And you'll also get a good handle on the calculate function, the most important function in the DAX language.
By the end of the course, you'll feel confident and comfortable writing DAX formulas.
Who this course is for:
Power BI beginners who are struggling to master the DAX language

User Reviews

Rating

average 0

Total votes0

Focused display

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes. His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.