Forum Discussion
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 tab...
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
Anonymous,
Can you also provide relationship between two tables? It will help decide whether to use RELATED, RELATEDTABLE or something else
Anonymous
Screen shot of relationship as requested,
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