Moving one column to another table without appending/merging

[whatisdaxneway]

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!

[v-stephen-msft · Accepted solution]

Hi @whatisdaxneway ,

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.

[whatisdaxneway]

The tables are related.

If I want the new column in the geography lookup VISN VALUE, I used:

VISN Value = RELATED(VISN) but this did not work.

I want to move the information from the VISN column in the Readiness table into the Geography lookup table without appending.

[whatisdaxneway]

Additionally, this does not work:

[AnkitKukreja]

Hi! @whatisdaxneway 

Can you provide some sample data and the expected solutions?

[AnkitKukreja]

Hi! @whatisdaxneway 

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.

[Shaurya]

Hi @whatisdaxneway,

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!