UNION – appending of multiple tables in DAX (DAX – Power Pivot, Power BI)
This is about the UNION function, which combines tables in Power BI or Power Pivot.
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.
What if the tables I want to combine have different columns names? Like one table has “Account” (for the name of the business) and the other has “Acct” for the same thing.
You are fucked!
Rename the columns of one table in Edit Query window to match the other. Simples.
Katuve – shame on you 🙁
You can use SELECTCOLUMN.
So UNION(
SELECTCOLUMN table1, “account”, table1[account],)
SELECTCOLUMN (table2, ” account”, table2[acct])
)
or something like that