Power BI: How to Add Column from Another Table

Using the Power BI functions between tables is very easy

by Milan Stanojevic
Milan Stanojevic
Milan Stanojevic
Windows & Software Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He's a PC enthusiast and he... read more
Updated on
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • Power BI can be used to create interactive data visualizations, and build dashboards and reports for data analysis and decision making
  • The simplest way to add a column from another table is to write the necessary formulas.
add column in power bi
XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix: This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:
  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Power BI has many great functions that make this Microsoft product one of the most desired tools for organizing and visualizing various sets of data.

However, many users can’t understand how to use some of these fine options. This is because Power BI is not so intuitive in some cases.

In this article, we will show you how to add a column from another table.

This issue was described by a user on the official Microsoft forum:

I have 2 tables: Table [A] and TimeZone. How do I add another colum in [A] that will use a column a vlaue in the TimeZone table without using a Merge Query? The Timezone table only contains one value which is the number of hours to offset. Ideally I would like to use this value as a parameter but have not figured out how to do it.

power bi column issue


So, the OP wants to use the number of hours as a parameter but didn’t figure out how to do that.

If you find yourself in the same situation, here are some solutions that will work for you.

Steps to add a column from another table in Power BI

1. Add a column from another table when there is a relationship between tables

Add a calculated column on Table [A] using the syntax: New Column = RELATED(TimeZone[Value])

2. Add a column from another table when there is not a relationship between tables

If you don’t use relationship, here is an alternative:

New Column =
var JoinCol = ‘TableA'[ID]
var NewCol = CALCULATE(MAX(‘TimeZone'[Value]),’TimeZone'[ID]=JoinCol)
return NewCol

3. Add a column using Power Query

  1. Select Edit Queries. This will open a new window in Power BI.power b edit queries button
  2. Go to the Add Column tab.
  3. Add an Index Column and name it Index.power bi add index column
  4. Add a Custom Column with this expression: Table2[ColumnName]{[Index]}

Conclusion

The solutions seem a little bit technical, especially the first two. Still, the option of adding a column from another table is for advanced users.

Fortunately, there is more than one way to approach this issue, each one being adapted to the needs of every user.

Did you find our solutions useful? Do let us know in the comments section below!

Still having issues? Fix them with this tool:

SPONSORED

Some driver-related issues can be solved faster by using a dedicated tool. If you're still having problems with your drivers, just download DriverFix and get it up and running in a few clicks. After that, let it take over and fix all of your errors in no time!

This article covers:Topics: