Скачать или смотреть LESSON 10040 | SUM, AVERAGE, MAX, MIN, CALCULATE FUNCTIONS IN DAX POWER BI | Free Course

In this video, I guide you through the essential aggregation functions in the DAX language using Power BI, explaining how to apply functions like SUM, AVERAGE, MAX, MIN, and standard deviation to real datasets. I walk you step by step through creating both measures and calculated columns, while showing how the filter and grouping contexts influence results in visuals and tables. You’ll learn how to reference tables and columns properly, distinguish between row and group-level aggregation, and adjust the data context using DAX's CALCULATE function. If you're working with Power BI data models, this lesson will help you understand how to summarize, group, and manipulate data effectively using DAX's built-in tools. Perfect for anyone building dashboards or reports who wants to deepen their DAX knowledge without fluff.

📈 Get the data packs: https://immalytics.com/packs?utm_sour...

🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  
🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  

💻 For all playlists, visit our website: https://immalytics.com

Calculated Comuns vs Measures:    • LESSON 10040 | MEASURES VS CALCULATED COLU...  
All about DAX Structure:    • LESSON 10030 | UNDERSTANDING DAX FORMULA S...  
Iteration:    • LESSON 10130 | ITERATION IN POWER BI AND P...  
Aggregation:    • LESSON 10140 | AGGREGATION OR SUMMARIZATIO...  
Grouping:    • LESSON 10150 | GROUPING IN POWER QUERY: TH...  

Chapters
00:00 Introduction to Aggregation Functions in DAX
01:20 Understanding Prerequisites: Measures, Calculated Columns, Grouping
03:00 Example Dataset Overview (Employee Table with Hours and Salaries)
04:30 Creating a Simple Measure Using SUM in Power BI
06:10 Visualizing Aggregated Data by Department
08:00 Creating a Calculated Column with the Same SUM Formula
09:50 Key Differences Between Measures and Calculated Columns
11:00 Changing Filter Context with the CALCULATE Function
12:40 Exploring Other Aggregation Functions: AVERAGE, MAX, MIN, STDEV
14:30 Overview of COUNT Functions and Closing Remarks

#dax #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver