Share this article
This article is translated in
Improve this guide
Power BI: How to Add Column from Another Table
Using the Power BI functions between tables is very easy
2 min. read
Updated onFebruary 8, 2024
updated onFebruary 8, 2024
Share this article
This article is translated in
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
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, but Power BI is not so intuitive in some cases.
This issuewas describedby 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.
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 relationships, 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
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!
Milan Stanojevic
Windows Toubleshooting 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 spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
2 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
