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 ...
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.
Shaurya
Memorable Member
Memorable MemberHi 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!