<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

DAX Guides - Aggregations

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.

DAX Guides - Aggregations
  • Course Info
  • Instructor
  • What to know beforehand
  • System Requirements

Course Description

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

Module 02 - What Are Aggregates?

Module 03 - File Tour and Setup 6 min.

Module 04 - SUM 9 min.

Module 05 - SUMX 6 min.

Module 06 - MAX 5 min.

Module 07 - MAXX 4 min.

Module 08 - MAXA 4 min.

Module 09 - MIN 3 min.

Module 10 - MINX 4 min.

Module 11 - MINA 3 min.

Module 12 - AVERAGE 3 min.

Module 13 - AVERAGEX 4 min.

Module 14 - AVERAGEA 3 min.

Module 15 - COUNTROWS 3 min.

Module 16 - COUNT 3 min.

Module 17 - COUNTX 5 min.

Module 18 - APPROXIMATEDDISTINCTCOUNT 3 min.

Module 19 - DISTINCTCOUNT 4 min.

Module 20 - DISTINCTCOUNTNOBLANK 4 min.

Module 21 - COUNTBLANK 3 min.

Module 22 - COUNTA 4 min.

Module 23 - COUNTAX 4 min.

Module 24 - PRODUCT 3 min.

Module 25 - PRODUCTX 6 min.

Module 26 - Advanced Aggregation Techniques 5 min.

Module 27 - Class Wrap Up 2 min.

This course includes:

  • 1+ hours of training
  • 28 Modules
  • * Access on mobile and browser
  • Certificate of Completion