Pragmatic Guides - DAX 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.
- Course Info
- Instructor
- What to know beforehand
- System Requirements
Course Description
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
- Intermediate level content
- Access on mobile and browser
- Certificate of Completion
