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.
-
A Proper Dataset: How to Prepare Data for Power Query
Learn what a proper dataset is for Power Query – headers, merged cells, data types, null values, and one cell,…
-
Power Query Folder: How to Automatically Combine Excel Files from a Folder
Learn how the Power Query Folder connector automatically combines multiple Excel or CSV files into one table, and how automatic…
-
How to Embed an Interactive Power BI Chart on a Website
Learn how to publish a Power BI report through Power BI Service and embed an interactive chart on a website…
-
How to Build KPIs in Power BI: DAX Examples and Best Practices
Learn how to build KPIs in Power BI using DAX – target achievement, sales growth, and how filter context affects…
-
How DAX Understands Time: Time Intelligence Made Simple
Learn how DAX Time Intelligence functions calculate YTD, MTD, comparisons to last year, and moving periods in Power BI.
-
How DAX Sees Data: Row Context vs Filter Context
Learn the difference between Row context and Filter context in DAX, how they work together, and how CALCULATE changes filter…
-
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…