Forum Discussion
Table Relationship Doesn't Work.
Hi Anonymous
In fact, many to many relationship works.
In you scenario, why it doesn't work is that:
For example, in my test example,
there are two "a" values in table 1, also two "a" values in table2,
then use "RELATED" function in table1 to get "a" values from table2,
it can't determine which "a" to return.
For this scenario, you could follow my method(use aggregation) in my last post, it is a general way to solve this kind problems.
Regrading using tables with many to many relationship in power bi, you could refer to this article
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Best Regards
Maggie
Community SupportHi Anonymous
As tested, when there is no relationship between two tables, i can use column inside function "AVERAGE" in another table in this table
Which relationship you create? could you show me a screenshot?
Are there many duplicates for each value in "current ui a" or "accessories historical ui a" column?
Best Regards
Maggie
Hi Maggie,
Are there many duplicates for each value in "current ui a" or "accessories historical ui a" column?
Yes ,there are duplicates and I am converting excel report into power bi and excel has two tabsheet one for current and one for historical,both tables has common column UI .I have created many to many and both directional on accessories UI and Historical UI.
<Maggie>Which relationship you create? could you show me a screenshot?
I have created relationship on both tables using many to many and both directional.Please see below,