UNION – appending of multiple tables in DAX (DAX – Power Pivot, Power BI)
In this article we will put the table with red and blue cars together.
The UNION function can be (not only) used for new table creation. Let´s write it like this:
- Together = UNION('Blue cars';'Red cars')
New table contains rows from both (or many) tables together.