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.
-
Text Transformations in Power Query: 6 Steps You’ll Use Most Often
Learn the 6 most commonly used Power Query text cleanup steps – Trim, Replace Values, Extract, Split Column, Format, and…
-
Power Query Mistakes: Changed Type and Remove Columns Pitfalls
Learn why Changed Type and Remove Columns steps in Power Query often cause errors when data refreshes, and how to…
-
Power Query Editor: How Applied Steps, the Formula Bar, and M Code Work
Learn how the Power Query Editor works – Applied Steps, the Formula Bar, and M code. Understand the transformation chain…
-
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…