How to Union Two Tables in Power BI: A Comprehensive Guide Combining data from multiple tables is a common requirement in Power BI to create unified datasets for analysis and visualization. There are two primary methods to achieve this task in Power BI: using the DAX UNION function and using the Append Queries feature in Power Query. In this guide, we will walk you through the step-by-step process of both methods. Method 1: Using the DAX UNION Function The DAX UNION function allows you to combine two or more tables with identical columns into a single table. Here's how you can use the UNION function in Power BI: Launch Power BI Desktop and load the tables that you want to union.


Go to the Modeling tab on the Power BI ribbon.


Click on New Table to create a new DAX table.



Enter the following DAX formula to union two tables, for example:
Table = UNION('Query1','Query2')



Replace 'Query1' and 'Query2' with the actual table names you want to union.


Press Enter to create a new table with the combined data from both tables. Launch Power BI Desktop and load the tables that you want to union. Launch Power BI Desktop and load the tables that you want to union. Go to the Modeling tab on the Power BI ribbon. Go to the Modeling tab on the Power BI ribbon. Click on New Table to create a new DAX table. Click on New Table to create a new DAX table. Enter the following DAX formula to union two tables, for example:
Table = UNION('Query1','Query2') Enter the following DAX formula to union two tables, for example: Table = UNION('Query1','Query2') Table = UNION('Query1','Query2') Replace 'Query1' and 'Query2' with the actual table names you want to union. Replace 'Query1' and 'Query2' with the actual table names you want to union. Press Enter to create a new table with the combined data from both tables. Press Enter to create a new table with the combined data from both tables. Method 2: Using Append Queries in Power Query Appending queries in Power Query allows you to combine tables by stacking one on top of the other. Here's a step-by-step guide to using the Append Queries feature: Load the tables into Power Query by selecting the table and clicking on the Transform Data option.


In the Power Query Editor, select the first table you want to append.


Go to the Home tab on the Power Query ribbon.


Click on Append Queries and select Append Queries as New.



Choose the second table you want to append in the dialog box that appears.


Configure the append operation by selecting the appropriate options (e.g., append queries with matching columns).


Click OK to append the tables.


Once appended, you can further transform the data or load it into Power BI for analysis. Load the tables into Power Query by selecting the table and clicking on the Transform Data option. Load the tables into Power Query by selecting the table and clicking on the Transform Data option. In the Power Query Editor, select the first table you want to append. In the Power Query Editor, select the first table you want to append. Go to the Home tab on the Power Query ribbon. Go to the Home tab on the Power Query ribbon. Click on Append Queries and select Append Queries as New. Click on Append Queries and select Append Queries as New. Choose the second table you want to append in the dialog box that appears. Choose the second table you want to append in the dialog box that appears. Configure the append operation by selecting the appropriate options (e.g., append queries with matching columns). Configure the append operation by selecting the appropriate options (e.g., append queries with matching columns). Click OK to append the tables. Click OK to append the tables. Once appended, you can further transform the data or load it into Power BI for analysis. Once appended, you can further transform the data or load it into Power BI for analysis. Conclusion By following these two methods, you can effectively union two tables in Power BI using either DAX or Power Query. Choose the method that best suits your data structure and analysis requirements to integrate and consolidate your datasets seamlessly.

Walkthroughs, tutorials, guides, and tips. This story will teach you how to do something new or how to do something better.

Power BI: Two ways to Union Tables - DAX and Power Query

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

A Quick Guide to Listing All Measures in Power BI via DAX Studio

20 Herramientas de Inteligencia Empresarial (BI) más Populares en 2020

3 Key Advantages of Open-Source Intelligence

3 Ways You Can Build and Update Websites Using Data Pushes

4 of the Best Ways to Use AI in Business

A Quick Guide to Listing All Measures in Power BI via DAX Studio

20 Herramientas de Inteligencia Empresarial (BI) más Populares en 2020

3 Key Advantages of Open-Source Intelligence

3 Ways You Can Build and Update Websites Using Data Pushes

4 of the Best Ways to Use AI in Business

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps