UNION DAX Function
The UNION DAX function creates a union (join) table from a pair of tables. It returns a table that contains all the rows from each of the table argument expressions.
DAX Syntax UNION(table_expression1, table_expression2 [,table_expression]…)
The parameter table_expression is any DAX expression that returns a table.
Example: Let’s we have a table with name Query15 as shown in the image below:
And another table with name Query13, as shown in the image below.
DAX
Table 4 = UNION(Query15, Query13)
In the result below, we can see that the rows from the table are stacked just like the append operation in the power query.
