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: 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
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!
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
