Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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
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
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
Is this what you require?
I want to use the Column Modified into another data table
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,
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |