# Coffee roaster monthly files

A folder of monthly sales CSVs from a coffee roaster. February added an Origin column. Combine by column name and practise a real refresh with the April file.

Original, fictional practice data from Power Query Exercises. Free to use for learning and teaching.
Independent practice material; not affiliated with or endorsed by Microsoft.

## What's inside

- `monthly/sales-2026-01.csv` — January (no Origin column).
- `monthly/sales-2026-02.csv` — February (adds Origin).
- `monthly/sales-2026-03.csv` — March.
- `refresh-drill/sales-2026-04.csv` — April: copy it into monthly/ to practise a refresh.
- `queries/combine-monthly.pq` — Combine every monthly file: All CSVs in monthly/, matched by column name, with the source file.

## Honest labelling

The data files are plain CSV, JSON and XLSX files. The XLSX files contain values only: no formulas and no
embedded Power Query connection. The queries are .pq text you paste into Excel or Power BI yourself. They were
validated in the Power Query Exercises simulator against these exact files, not in Excel or Power BI.

## Follow along in Excel

1. Download the pack and extract the zip, for example to C:\PQE\<pack name>\.
2. In Excel (Microsoft 365 or 2016+ on Windows), go to Data → Get Data → From Other Sources → Blank Query.
3. In the Power Query Editor choose Home → Advanced Editor, select everything and paste the contents of the .pq file.
4. Change the PackFolder line to the folder you extracted to, then choose Done.
5. If Excel asks about privacy levels or file access, allow access to that folder. Then choose Home → Close & Load.

## Follow along in Power BI Desktop

1. Download the pack and extract the zip.
2. In Power BI Desktop choose Home → Transform data to open the Power Query Editor, then Home → New Source → Blank Query.
3. Choose Home → Advanced Editor, paste the contents of the .pq file and change the PackFolder line to your folder.
4. Choose Done, check the preview against the expected rows in the query header, then Close & Apply.

## Then try this

1. Load the query, then copy refresh-drill/sales-2026-04.csv into the monthly folder and refresh. April's rows appear with their SourceFile.
2. January has no Origin column, so its Origin cells are null. That's correct: don't fill it with a guess.
