Master DAX aggregation functions like COUNT, SUM, AVERAGE, and advanced techniques such as COUNTX. Learn practical tips to optimize data analysis in Power BI and Excel, enhancing your reporting and decision-making skills.
This course will teach participants how to effectively use DAX aggregation functions to analyze and manipulate data in Power BI and Excel. Participants will learn how to work with essential DAX functions such as COUNT, SUM, AVERAGE, and MAX, as well as advanced techniques like APPROXIMATEDISTINCTCOUNT, PRODUCTX, and COUNTX. Through hands-on exercises, participants will gain practical experience in applying these functions to solve complex data analysis challenges. The course will also cover best practices for leveraging DAX to optimize reporting and enhance data-driven decision-making. Whether you're a data analyst or a business intelligence professional, this course will help you master DAX aggregation functions and take your data analysis skills to the next level. Join us to unlock the full potential of DAX and transform the way you work with data!
Course Outline ( Free Preview)
DAX Guides - Aggregations - What You Need to Get Started
Module 01 - Introduction
In this introductory course on DAX Guides, Greg from Pragmatic Works delves into the essential aggregation functions within the DAX language, crucial for data analysis and expression. Students will learn about various functions, from basic iterators to advanced scenarios, with a focus on practical applications and real-life examples. By the end of the course, participants will have a solid understanding of how to use DAX aggregation functions effectively in Power BI, enhancing their data analysis skills.
Module 02 - What Are Aggregates?
In this session, Greg introduces the concept of aggregations in Power BI, emphasizing their importance in data analysis. He explains that DAX (Data Analysis Expressions) is a powerful formula language used to perform complex calculations and gain deeper insights from data.
Module 03 - File Tour and Setup6 min.
In this video, Greg provides a comprehensive overview of the starting file for a class on DAX aggregation functions in Power BI. He explains that the file includes pre-made tables and visualizations for various functions like SUM and SUMX, designed to help students follow along and understand the basics to advanced concepts. Greg also highlights the importance of creating a measures table to keep aggregation measures organized, ensuring a smooth learning experience.
Module 04 - SUM9 min.
In this short video, we’ll guide you through the process of using the SUM function in DAX to aggregate values in your datasets.
Module 05 - SUMX6 min.
In this short video, we’ll walk you through the steps to use the SUMX function to perform row-by-row calculations and aggregate the results in Power BI.
Module 06 - MAX5 min.
In this short video, we’ll show you how to leverage the MAX function in DAX to find the highest value in your datasets in Power BI
Module 07 - MAXX4 min.
In this short video, we’ll show you how to leverage the MAXX function in DAX to find the highest value in your datasets in Power BI
Module 08 - MAXA4 min.
In this short video, we’ll show you how to leverage the MAXA function in DAX to find the highest value in your datasets in Power BI.
Module 09 - MIN3 min.
In this short video, we’ll show you how to leverage the MIN function in DAX to find the highest value in your datasets in Power BI.
Module 10 - MINX4 min.
In this short video, we’ll guide you through the process of using the MINX function to perform row-by-row calculations and find the smallest value in your datasets in Power BI.
Module 11 - MINA3 min.
In this short video, we’ll explain how to use the MINA function to find the smallest value in your datasets, including text and logical values in Power BI.
Module 12 - AVERAGE3 min.
In this short video, we’ll explain how to use the AVERAGE function in Power BI
Module 13 - AVERAGEX4 min.
In this short video, we’ll explain how to use the AVERAGEX function in Power BI.
Module 14 - AVERAGEA3 min.
In this short video, we’ll explain how to use the AVERAGEA function in Power BI.
Module 15 - COUNTROWS3 min.
In this short video, we’ll show you how to leverage the COUNTROWS function to count the number of rows in a table or a table expression in Power BI.
Module 16 - COUNT3 min.
In this short video, we’ll show you how to leverage the COUNT function to count the number of non-blank cells in a column.
Module 17 - COUNTX5 min.
In this short video, we’ll show you how to leverage the COUNTX function to count the number of rows that result from evaluating an expression over a table in Power B.
Module 18 - APPROXIMATEDDISTINCTCOUNT3 min.
In this short video, we’ll show you how to leverage the APPROXIMATEDISTINCTCOUNT function to quickly estimate the number of distinct values in a column in Power BI.
Module 19 - DISTINCTCOUNT4 min.
Unlock the power of the DISTINCTCOUNT function in Power BI! Learn how to quickly and easily remove duplicates from your counts in Power BI data, ensuring your reports are accurate and insightful. Perfect for beginners and pros alike.
Module 20 - DISTINCTCOUNTNOBLANK4 min.
Unlock the power of the DISTINCTCOUNTNOBLANK function! In this short video, you’ll learn how to use this powerful function to count unique values while ignoring blanks
Module 21 - COUNTBLANK3 min.
In this video, we’ll dive into the COUNTBLANK function in DAX, which will help you understand how to effectively use CountBlank to count the number of blank values in your data sets.
Module 22 - COUNTA4 min.
In this video, we’ll explore the COUNTA function in DAX, which allows you to count non-blank values in your data sets.
Module 23 - COUNTAX4 min.
In this short video, we’ll show you how to leverage the COUNTX function to count the number of rows that result from evaluating an expression over a table in Power BI.
Module 24 - PRODUCT3 min.
In this short video, we dive into how to use the "PRODUCT" function in Power BI.
Module 25 - PRODUCTX6 min.
In this short video we showcase how to use the "PRODUCTX" function in Power BI.
Module 26 - Advanced Aggregation Techniques5 min.
In this session, Greg demonstrates the application of advanced aggregations in data analysis, specifically focusing on creating a seven-day moving average for sales. He explains the use of the `AVERAGEX` function and the `DATESINPERIOD` function to calculate the moving average, emphasizing the importance of understanding these functions for dynamic and complex calculations. Greg encourages students to explore further learning resources to deepen their knowledge of DAX functions and their practical applications.
Module 27 - Class Wrap Up2 min.
Congratulations on completing the course! In this course, Greg Treziak from Pragmatic Works provided an in-depth exploration of aggregation functions in DAX, covering both basic and advanced scenarios. Key concepts included dynamic calculations with iterators (X functions), the use of A functions for true/false assessments, and the distinction between filter context and row context in calculations. By the end of the session, you now have a solid understanding of how to apply these functions to enhance your data analysis and reporting skills.
Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!