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.
- What you'll learn
- Course Description
- Course Outline
- Instructor
- System Requirements
- What to know beforehand
What you'll learn
This course includes:
- 1+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
This course includes:
- 1+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Outline
DAX Guides - Aggregations - What You Need to Get Started
Module 01 - Introduction 5 min.
Module 02 - What Are Aggregates? 6 min.
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 hours of training
- Access on mobile and browser
- Certificate of Completion
Instructor
This course includes:
- 1+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 1+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 1+ hours hours of training
- Access on mobile and browser
- Certificate of Completion