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.

1 Comment

  1. 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.

Leave a Reply

Your email address will not be published.

*

clear formPost comment