Скачать или смотреть LESSON 10030 | UNDERSTANDING DAX FORMULA STRUCTURE | Free DAX Course

In this video, I walk you through the core structure of DAX formulas in Power BI, explaining how to properly reference tables and columns, differentiate between measures and calculated columns, and apply functions like SUM and SUMX. You'll learn how table names and column names serve as unique identifiers, how arguments and functions work together within a formula, and how to use expressions for row-by-row operations using iteration. I also show you how calculated columns and measures differ in use and impact, and I demonstrate real examples inside Power BI, including how to handle naming conflicts and use simple arithmetic expressions without DAX functions. By mastering this syntax and terminology, you'll be equipped to build efficient and scalable calculations for your reports.

📈 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

Chapters:
00:00 Understanding the structure of DAX formulas
01:20 How tables and column references work in Power BI
03:10 Referencing entire tables vs. specific columns
05:00 Syntax for referencing columns within DAX formulas
07:20 Introduction to DAX functions, arguments, and expressions
09:30 Writing a basic SUM function and understanding calculation names
12:10 Using DAX formulas without functions: direct arithmetic operations
14:00 Understanding calculated columns vs. measures in Power BI
17:00 Using SUMX: how iterative functions differ from aggregation
20:10 Creating DAX calculations directly in Power BI with real data
23:00 Example: Building a calculated column for profit
25:00 Best practices and summary of DAX formula structure

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