Forum Discussion
Moving one column to another table without appending/merging
I need to move a column of numbers from "Readiness" table to my Geography lookup table.
The two tables are related.
I've tried to use RELATED but that doesnt work.
I also do not have the "home table" option in my ribbon.
Please help!
Hi Anonymous ,
Because of the one-to-many relationship, the RELATED function cannot be used in Table Geography lookup, but can be used in Table Readiness.
Because of your relationship, your one of the rows may match multiple VISN values, and you need to determine the specific logic.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- Shaurya
Memorable Member
Hi Anonymous,
I think the LOOKUP() function will help you pull the required column.
Please refer to:
https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
Mark this post as a solution if that works for you!
- AnkitKukreja
Super User
Hi! Anonymous
You cannot move the column from one table to other. But, you can either merge it in power query or use lookup in dax to get that column there.
- AnkitKukreja
Hi! Anonymous
Can you provide some sample data and the expected solutions?
Hi Anonymous ,
Because of the one-to-many relationship, the RELATED function cannot be used in Table Geography lookup, but can be used in Table Readiness.
Because of your relationship, your one of the rows may match multiple VISN values, and you need to determine the specific logic.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
