Power BI: How to Add Column from Another Table


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

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Manually Add Row to Table
Power BI: How to Add Index Column to Table
Power BI: How to Count Distinct Values in Column

Leave a Reply

Your email address will not be published. Required fields are marked *