Training videos for learning DAX FOR POWER BI

We have 9 DAX for Power BI videos listed below. You might also like to consider booking a place on one of our online or classroom Power BI courses, where you will meet the owls behind the videos!

DAX for Power BI Part 1 - Getting Started with DAX for Power BI

Posted by Andrew Gould on 14 August 2021

This first video in our DAX for Power BI series is designed to get you set up and ready to follow along with the rest of the series, and to give you an idea of what you can do with DAX. You'll see quick examples of DAX calculated columns, DAX measures, DAX table expressions and using variables in DAX expressions.

DAX for Power BI Part 2.1 - Basic Calculated Columns in DAX

Posted by Andrew Gould on 17 August 2021

This video explains how to create calculated columns in DAX. You'll learn about the important concept of Row Context and a variety of ways to reference a column in a DAX expression. You'll see how to add comments and lay out your code for readability. You'll learn about the order of operation and how to control it and how to use some basic DAX functions. You'll also see how DAX adjusts the data type of a column as you make changes to the expression. Finally, you'll learn how to concatenate multiple values to create a longer value.

DAX for Power BI Part 2.2 - The If Function

Posted by Andrew Gould on 19 August 2021

This video shows you how to create calculated columns using the If function in DAX. You'll learn how to write basic logical tests, how to create columns to use as categories or values and how to write nested If functions. You'll also find out how to use the And function and && operator, as well as the Or function and || operator. Finally, you learn how to use the In operator in DAX.

DAX for Power BI Part 2.3 - The Switch Function

Posted by Andrew Gould on 20 August 2021

This video explains how to use the Switch function in calculated columns in DAX. You'll learn how to test a column value against a list of constants, how to use the True function to enable your Switch function to include logical tests, and the importance of the order in which you write those tests.

DAX for Power BI Part 2.4 - Working with Blanks

Posted by Andrew Gould on 21 August 2021

This video shows you how to work with blanks in your DAX expressions for calculated columns. You'll learn you to test for blanks using the IsBlank function and the Blank function. You'll see the difference between the equal to and strictly equal to operators and the importance of that difference when it comes to working with blanks. You'll learn how to produce a blank as the result of an expression and what happens when you involve a blank in some basic arithmetic. Finally, you'll see how to concatenate a blank into a string and how to use the Coalesce function to produce a replacement value.

DAX for Power BI Part 2.5 - Working with Text in Calculated Columns

Posted by Andrew Gould on 23 August 2021

This video covers a variety of DAX functions for working with text. You'll learn how to join text together using the Concatenate and CombineValues functions and the concatenation operator. You'll see how to use the Format function to apply standard and custom formats to values. You'll learn how to extract text from the left, right and middle of a string, as well as how to locate the characters you want to extract using the Find or Search functions. You'll find out how to remove extra spaces from a string and how to calculate the length of a string. Finally, you'll see how to use the Replace or Substitute functions to replace one piece of text with another.

DAX for Power BI Part 2.6 - Working with Dates in Calculated Columns

Posted by Andrew Gould on 24 August 2021

This video shows you the basics of working with dates in calculated columns. You'll learn what the Auto Date Time feature in Power BI does. You'll see how to use functions such as Year, Quarter, Month and Day to extract parts of dates and how to use the Format function to return month and day names. You'll learn how to write literal dates in your expressions and how to calculate a date from its constituent parts using the Date function. You'll see how to calculate future and past dates using DateAdd and why that dosn't always work, as well as how to get around the problem using basic arithmetic. FInally, you'll learn how to calculate the difference between dates using the DateDiff function.

DAX for Power BI Part 2.7 - Error Functions in Calculated Columns

Posted by Andrew Gould on 06 September 2021

This video explains how to deal with errors in your DAX calculated column expressions. You'll learn how to use the IsError and IfError functions to replace errors when they occur, as well as how to use the If function to avoid some errors in the first place. You'll see how to use the Divide function to help avoid divde by zero errors. You'll see errors related to data type conversions and also how to use the alternate result parameter of some functions to avoid errors.

DAX for Power BI Part 3.1 - Relationships and the Related Function

Posted by Andrew Gould on 26 September 2021

This video explains some of the basic concepts of data models involving multiple tables in Power BI. You'll learn about one-to-many or many-to-one relationships and how to get Power BI to automatically detect relationships between tables. You'll see how to create relationships manually and learn some basic data model terminology. You'll see what happens when you have multiple tables which aren't related and how filters propagate through the relationships in your model. You'll also see how to manipulate the direction of a relationship to influence how filters behave. In the final part of the video you'll learn how and why to use the Related DAX function to reference fields in different tables.

This page has 0 threads Add post