Training videos for learning DAX FOR POWER BI

We have 22 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.

DAX for Power BI Part 3.2 - The LookupValue Function

Posted by Andrew Gould on 23 October 2021

This video explains how to use the LookupValue function in DAX. You'll learn how to lookup values between tables which don't have relationships and how to deal with items which return no matching value. You'll see how to nest LookupValue functions to search for values in a chain of tables. You'll also learn how to find values by matching on multiple columns and how to lookup values in the same table in a different column.

DAX for Power BI Part 4.1 - Getting Started with Measures

Posted by Andrew Gould on 29 October 2021

This video provides an introduction to working with DAX measures in Power BI. You'll learn how to add measures to a data model and how measures differ from calculated columns. You'll see how to organise the measures in your model using display folders and measure tables. You'll be introduced to the concept of filter context and how this affects the result returned by a measure. You'll see some examples of using measures to format visuals rather than to simply display a value. You'll also see a basic example of manipulating the filter context to influence which values are used by a measure.

DAX for Power BI Part 4.2 - Sum, SumX and Other Aggregate Functions

Posted by Andrew Gould on 19 November 2021

This video explains how to use DAX aggregate functions such as Sum, Average, Min and Max to aggregate a single column. You'll also learn how to use SumX, AverageX, MinX and MaxX to aggregate the results of expressions.

DAX for Power BI Part 4.3 - Counting Values and Rows

Posted by Andrew Gould on 26 November 2021

This video shows you a variety of ways to count things in DAX. You'll learn how to count values in a column using the COUNT and COUNTA functions, and what effect blanks have on the result of the count. You'll see how to use the COUNTROWS function to avoid issues caused by blanks and how to count unique values using the DISTINCTCOUNT and DISTINCTCOUNTNOBLANK functions. Finally, you'll learn how to count the result of an expression using the COUNTX and COUNTAX functions, as well as how to combine these with the IF function to create a rudimentary CountIf setup.

DAX for Power BI Part 4.4 - Using Variables

Posted by Andrew Gould on 30 November 2021

This video explains how to use variables in DAX to break a large calculation into discrete parts. You'll learn how to declare and assign values to variables in calculated columns and measures, and how to refer to variables in your code. You'll see how to declare variables within a function to create variables with a limited scope, and how to create variables which can hold the results of a table expression.

DAX for Power BI Part 4.5 - Quick Measures

Posted by Andrew Gould on 04 December 2021

This video shows you how to create and edit Quick Measures in Power BI Desktop to save time writing DAX code. You'll learn how to add quick measures, how to edit the code afterwards and how to create a range of examples.

DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions

Posted by Andrew Gould on 14 December 2021

This video shows you how to apply filters in your DAX measures using the Calculate, Filter and CalculateTable functions. You'll learn how to apply single and multiple filters, how to use the And, Or and In operators and how to work with numbers, text and dates. You'll also see the limitations of filter arguments in the Calculate and CalculateTable functions and how to nest the Filter function to get around these limitations.

DAX for Power BI Part 5.2 - Removing Filters in Measures

Posted by Andrew Gould on 20 December 2021

This video explains how to remove filters in DAX measures using the All and RemoveFilters functions. You'll learn how to remove all the filters from a measure, how to remove filters from specific tables and how to remove filters from specific columns. You'll also see how to create measures which compare filtered and unfiltered values to show, for example, the percentage contribution of values to totals.

DAX for Power BI Part 5.3 - Replacing and Keeping Filters in Measures

Posted by Andrew Gould on 21 December 2021

This video shows how to both replace existing filters in a measure and how to retain an existing filter using the KeepFilters function.

DAX for Power BI Part 5.4 - Removing Filters with AllSelected and AllExcept

Posted by Andrew Gould on 24 December 2021

This video explains how to use the AllSelected and AllExcept functions to remove filters in your DAX measures. You'll learn how to remove all the filters and only the specified filters using the All function; how to remove all of the filters applied by a Power BI visual using the AllSelected function; and how to remove all filters except for the ones you specify using the AllExcept function.

DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions

Posted by Andrew Gould on 15 January 2022

This video shows you how to get started with time intelligence functions in DAX. You'll learn how to make Power BI create a date table for each date column in your data model automatically. You'll also learn what the auto date table contains and why it's important for the operation of the time intelligence functions. You'll see how to display different levels of a date hierarchy and how to use the DateAdd function to modify the filter context applied to a measure to compare a calculation with past and future dates. Finally, you'll learn how to use the SamePeriodLastYear function as a shorthand for a specific use of the DateAdd function.

DAX for Power BI Part 6.2 - Comparing Date Ranges

Posted by Andrew Gould on 15 January 2022

This video explains how to use DAX time intelligence functions to modify the filter context applied to a measure, allowing you to compare calculations for different time periods. You'll learn the differences between the DateAdd, SamePeriodLastYear, PreviousYear and ParallelPeriod functions. You'll also see how to enter specific dates using the DateValue and Date functions, and how to use these dates in the DatesBetween function. Finally, you'll learn how to calculate moving averages using FirstDate and LastDate functions and the DatesInPeriod function.

DAX for Power BI Part 6.3 - Calculating Running Total or To-Date Values

Posted by Andrew Gould on 17 January 2022

This video explains how to use a range of DAX Time Intelligence functions to calculate running totals and to-date values in your measures. You'll learn how to use the FirstDate and LastDate functions to calculate the start and end of intervals and combine these with the DatesBetween function. You'll see how to use the StartOfYear and EndOfYear functions, as well as the DatesYTD, DatesQTD and TotalYTD functions. Finally, you'll learn how to set the year end date to a different date than December 31st for a range of time intelligence functions.

This page has 0 threads Add post