Blog
Practical Excel, Power Query and Power BI solutions
Useful articles on Excel, Power Query, Power BI and Report Automation – from simple formulas to fully automated reports.
Learn to join Excel tables with XLOOKUP
A clear, practical example of how to use XLOOKUP quickly and without errors.
-
ALL, REMOVEFILTERS, and KEEPFILTERS: How DAX Controls Filter Context
Learn how DAX functions ALL, REMOVEFILTERS, and KEEPFILTERS control filter context in Power BI – differences, examples, and when to…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…