DAX CALCULATE: The Most Powerful Power BI Function
Learn how the DAX CALCULATE function works in Power BI – syntax, examples, changing filter context, and common mistakes.
-
-
DAX X Iterator Functions: How They Work and When to Use Them
Learn how DAX iterator functions SUMX, AVERAGEX, COUNTX, and RANKX work in Power BI, the difference from SUM, and when to use them.
-
DAX COUNT Functions: Which One to Choose
Learn the differences between DAX COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT, and COUNTX functions in Power BI – and when to use each.
-
Introduction to DAX: What Every Power BI User Should Know
Learn DAX basics in Power BI – calculated columns vs measures, row and filter context, X functions, and Time Intelligence.
-
Star vs Snowflake Schema: Which to Choose in Power BI
Learn the difference between Star and Snowflake schema in a Power BI data model – when to choose which, and why simplicity usually wins.
-
Data Model and Relationships in Power BI: Why They Matter
Learn what a Power BI data model is, what relationship types exist, how filter direction works, and data model best practices.
-
Power Query: The First Step Toward Clean Power BI Data
Learn what Power Query and the ETL process are in Power BI – Extract, Transform, Load, common actions, and typical data preparation mistakes.
-
What Is Power BI: Microsoft’s Data Analytics Tool
Learn what Power BI is, where it’s used, its ecosystem (Desktop, Service, Mobile, Gateway), and how to get started with this tool.
