Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using Data from One Table in Another Table

Hi,

 

I'm new to Power BI, and I have two table queries, and I want to take a column from one table and enter the data into another table.

 

I have tried using RELATED but it does not find my table, the table has a relationship, but for some reason and I don't know why I am not able to get the column I need.

 

Any help would be greatfully received.

 

Thank you!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    In this case, I would suggest using Edit Queries to merge the two tables to get Modified column. RELATEDTABLE only works in conjuction with numeric values and aggregation, but since Modified is non-numeric column, you cannot use RELATEDTABLE

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    Have you tried RELATEDTABLE instead? RELATED is used to get data from the one side of a relationship and RELATEDTABLE is used to get data from the many side of a relationship

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous

       

      Thank you for coming back to me, I am not again 100% sure on what I need to enter on RELATEDTABLE, I do get a little further with this but I think I may be putting the wrong information into the column

      Screen Shot of message

       

       

       

       

       

      Thank you

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

         

        Anonymous,

        Can you share a screenshot of your data model?