Merge & append › Table.Combine27 / 47

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeTable.Combine

Table.Combine: append 2024 and 2025 sales

Mr. Hendra runs a souvenir distributor in Semarang. His POS system exports each year's sales to a separate file, but he wants a single table for a two-year trend chart in Power BI. The Penjualan2024 and Penjualan2025 queries have exactly the same columns.

Task

Stack both tables with Table.Combine (Append Queries): the 2024 rows on top, then the 2025 rows below them. Result: 5 columns Tanggal, Kota, Produk, Qty, Total and 80 rows (40 + 40), each table keeping its original row order.

Data sourcesPenjualan2024Penjualan2025

Required functionsTable.Combine

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Run previewCtrlEnter
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Append stacks the rows of several tables into one long table. Columns are matched by name.
Hint 2
Table.Combine takes one argument: a list of tables, written in curly braces { }. The order of the tables in the list sets the order of the result rows.
Hint 3
#"Appended Query" = Table.Combine({___, ___}), then return that step after in.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

let
    Source = Penjualan2024,
    #"Appended Query" = Table.Combine({Source, Penjualan2025})
in
    #"Appended Query"

Explanation

Table.Combine({Source, Penjualan2025}) is the code behind the Append Queries button (Source holds Penjualan2024 here). All 2024 rows come first because that table is listed first. Columns are matched by name, not position, so the second table may order its columns differently as long as the names match exactly, including casing.
A common mistake is using Merge here. Merge adds columns from another table (sideways), while Append adds rows (downwards). Tip: when a 2026 file arrives, just add that table to the same list.

Power Query· sources: Penjualan2024 Penjualan2025

let
    Source = Penjualan2024
in
    Source

Loading the Advanced Editor…

Edit the M code until the result matches, then press Check answer.

Validation result