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.
-
The Power BI Process: Power Query, Data Model, DAX, and Visualizations
Learn how the entire Power BI process works – from data preparation with Power Query, through the data model and…
-
Date & Time Transformations in Power Query: Types, Extraction, and Locale Errors
Learn how to handle dates and time in Power Query – Date/DateTime type, extracting year and month, creating dates from…
-
Group By in Power Query: How to Group Data and Calculate Totals
Learn how to use Group By in Power Query – grouping data and calculating totals, averages, and counts. Simple and…
-
Conditional Column vs Custom Column in Power Query: When to Use Which
Learn the difference between Conditional Column and Custom Column in Power Query – when to use which, practical formula examples,…
-
Unpivot and Pivot in Power Query: How to Fix Messy Tables
Learn when to use Unpivot and Pivot in Power Query – how to turn columns into rows and back, and…
-
Merge vs Append in Power Query: How to Combine Tables Correctly
Learn the difference between Merge and Append in Power Query – when to use which, Join types, key column cleanup,…
-
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…