📦 Appending Data

Goal: Combine two tables into one list.
Rule: Tables must have the same number of columns.

Jan Sales (Table 1)
Feb Sales (Table 2)
Result: Master Table
Ready...

💻 DAX Formula

-- Combine historical and current data
EVALUATE All_Sales =
UNION(
Sales_Jan, -- 1. Top Table
Sales_Feb -- 2. Bottom Table
)

-- Note: Duplicates are KEPT (unlike SQL Union)
Total Rows:
0