How to Create a New Column in Power BI from Values from a Second Table

Power BI is a powerful business intelligence tool that allows you to analyze and visualize data from various sources. One of the key features of Power BI is the ability to create new columns in your data model. In this article, we will guide you through the process of creating a new column in Power BI using values from a second table.

Step 1: Importing the Data

The first step is to import the data into Power BI. You can import data from various sources such as Excel, CSV files, databases, or even web sources. For the purpose of this tutorial, let's assume you have already imported two tables into Power BI: Table1 and Table2.

Step 2: Understanding the Relationship

Before we can create a new column using values from a second table, we need to establish a relationship between the two tables. A relationship is a connection between two tables based on a common column. In our case, let's assume that both Table1 and Table2 have a column called "ID" that can be used to establish the relationship.

To establish the relationship, follow these steps:

1. Select the "Modeling" tab in the Power BI ribbon.
2. Click on the "Manage Relationships" button.
3. In the "Manage Relationships" window, click on the "New" button.
4. Select Table1 as the "Table" and ID as the "Column".
5. Select Table2 as the "Related Table" and ID as the "Related Column".
6. Click on the "OK" button to create the relationship.

Step 3: Creating a New Column

Now that we have established the relationship between Table1 and Table2, we can proceed to create a new column using values from Table2. Follow these steps:

1. Select Table1 in the "Fields" pane on the right-hand side of the Power BI window.
2. Click on the "Modeling" tab in the Power BI ribbon.
3. Click on the "New Column" button.
4. In the formula bar at the top, enter a name for the new column, for example, "NewColumn".
5. Enter the formula to retrieve the desired value from Table2. For example, if Table2 has a column called "Value" that you want to use, the formula would be: NewColumn = RELATED(Table2[Value]).
6. Press Enter to create the new column.

That's it! You have successfully created a new column in Power BI using values from a second table. The new column will now be available for analysis and visualization in your Power BI reports.

Conclusion

Power BI provides a simple yet powerful way to create new columns using values from a second table. By establishing relationships between tables and utilizing the RELATED function, you can enhance your data model and gain deeper insights into your data.

References