Power Bi Dax Essentials: Basic Dax Formulas And Functions
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.29 GB | Duration: 4h 4m
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.29 GB | Duration: 4h 4m
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
Requirements
A basic knowledge of Microsoft Power BI is assumed as well as Power BI Desktop (freely available)
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.
Overview
Section 1: Introduction
Lecture 1 0101-Welcome to the Course
Lecture 2 0102-Downloading the Course Files
Lecture 3 0103-DAX Overview
Lecture 4 0104-DAX Objects
Lecture 5 05-DAX Syntax and the Formula Bar
Lecture 6 0106-Calculated vs Computed Columns
Lecture 7 0107-Calculated Columns and Visuals
Section 2: 02-Calculated Columns
Lecture 8 0201-RELATED Function
Lecture 9 0202-RELATED VS LOOKUPVALUE
Lecture 10 0203-RELATEDTABLE Function
Section 3: 03-Conditional Statements
Lecture 11 0301-Nested IFs
Lecture 12 0302-AND Operator
Lecture 13 0303-Conditional Concatenation
Lecture 14 0304-OR Operator
Lecture 15 0305-IN Statement
Lecture 16 0306-SWITCH Function
Section 4: 04-Calculated Tables
Lecture 17 0401-Cloning a Table
Lecture 18 0402-ADDCOLUMNS
Lecture 19 0403-FILTER
Section 5: 05-Measures
Lecture 20 0501-Implicit Measures
Lecture 21 0502-Aggregating Columns
Lecture 22 0503-COUNT Function Variations
Section 6: 06-Iterator Functions
Lecture 23 0601-The SUMX Function
Lecture 24 0602-The AVERAGEX Function
Lecture 25 0603-The MAXX Function
Lecture 26 0604-The MINX Function
Section 7: 07-CALCULATE Function Basics
Lecture 27 0701-Basic Filter
Lecture 28 0702-ALL and REMOVEFILTERS
Lecture 29 0703-Percent of Total
Lecture 30 0704-Percent of Selected
Lecture 31 0705-Calculate Outcomes
Lecture 32 0706-CONTAINSSTRING
Section 8: 08-Common DAX Errors
Lecture 33 0801-Example 1
Lecture 34 0802-Example 2
Lecture 35 0803-Example 3
Lecture 36 0804-Example 4
Lecture 37 0805-Example 5
Power BI beginners who are struggling to master the DAX language