Table of Contents
To add a column from another table in Power BI, you can use the “Merge Queries” function. First, go to the “Edit Queries” menu and select the table that you want to add the column to. Then, click on the “Merge Queries” option and choose the table that contains the column you want to add. Next, select the column that you want to merge and click on “OK”. This will create a new table with the added column. Finally, you can expand the column by clicking on the small arrow icon next to it and selecting the columns you want to include in your original table. This will add the selected column from the other table to your original table in Power BI.
The easiest way to add a column from another table in Power BI is to use the LOOKUPVALUE function as follows:
Conf = LOOKUPVALUE(data2[Conference], data2[Team], data1[Team])
This particular example adds the column named Conference from the table named data2 to the table named data1 based on matching the values from the Team columns between the two tables.
The following example shows how to do so in practice.
Example: How to Add Column from Another Table in Power BI
Suppose we have the following table in Power BI named data1:
And suppose we have another table named data2:
Suppose that we would like to add the column named Conference from the table named data2 to the table named data1 based on matching the values from the Team columns between the two tables.
To do so, we can make the data1 table active, then click the Table tools tab and then click the New column icon:
Then type the following formula into the formula bar:
Conf = LOOKUPVALUE(data2[Conference], data2[Team], data1[Team])
This will create a new column named Conf that contains the values from the Conference column in data2:
Note: You can find the complete documentation for the LOOKUPVALUE function in DAX .
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: