How to append two tables in DAX

The UNION function is DAX is used to merge two tables for data analysis. If you input two tables, it will return a new table that has all rows from each of the input tables (given the number of columns is the same). That table will have the same columns as in the Table 1 expression, with those from both tables merged based on their positions. Duplicate rows are retained; this result is a “union all.”

For example, to append two tables, Table1 and Table2, here is how the DAX code should look:

The AppendedTable code will generate a new table that includes all the rows from both Table 1 and Table 2.

Note: The new table does not retain the relationships of the original tables, so you will need to establish new relationships.