Three systems that name the same truck differently
A carrier’s data about the same truck lives in three places. In the TMS it is V-104. On the fuel-card…
-
-
Case study: an Etsy sales dashboard from CSV in one Refresh
Etsy sellers get a lot of data – but usually as a CSV export, not a clear picture. How much…
-
Why Power Query Beats Copy/Paste
Copy/Paste is the most natural way to move data into a report – everyone starts there. And while the report…
-
5 Common Power Query Mistakes (and How to Avoid Them)
Power Query is a powerful tool, but it usually „breaks” not for complicated reasons, but because of a few of…
-
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 text, and fixing Locale problems.
-
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 advanced examples.
-
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, and a common mistake.
-
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 how to avoid common mistakes.
-
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, and common mistakes.
-
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 Column From Examples.
