Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Additionally, this does not work:

     

     

    • AnkitKukreja's avatar
      AnkitKukreja
      Icon for Super User rankSuper User
      3 years ago

      Hi! Anonymous 

       

      Can you provide some sample data and the expected solutions?