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.
-
How to Merge Excel Tables by ID Using XLOOKUP
Learn how to merge two Excel tables using a shared ID column with XLOOKUP. Simple merging logic and a practical…
-
VLOOKUP Not Working? 3 Common Mistakes and How to Fix Them
Learn the 3 most common VLOOKUP mistakes in Excel tables – wrong column numbers, breaking formulas, left-side lookups – and…
-
Why It’s Worth Switching from VLOOKUP to XLOOKUP in Excel
Learn why it’s worth switching from VLOOKUP to XLOOKUP in Excel tables – fewer errors, simpler syntax, and more reliable…
-
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,…