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
Impactful IndividualBased on the error:
"The column 'Accessories Historical Data[ACCESSORIES HISTORICAL UI A]' either doesn't exist or doesn't have a relationship to any table available in the current context.”
it is pretty much what it says. Either the column is renamed or deleted, or the columns in the calculation do not have a relationship defined between the tables they reside in.
<Nirvana>it is pretty much what it says. Either the column is renamed or deleted, or the columns in the calculation do not have a relationship defined between the tables they reside in.
>I did check that column is available and never ever renamed or delted.
>table does have relationship and when I typed formula intelisense shows me column name (where I marked it in yellow colour) and when I type formula intelisense does not show me column name(where I marked it in red colour)
Current 2017 AG = IFERROR(CALCULATE(AVERAGE('Accessories Historical Data'[HISTORICAL 2017 Duplicate with Calculation]),
FILTER('01-Accessories','01-Accessories'[Current UI A]=RELATED('Accessories Historical Data'[ACCESSORIES HISTORICAL UI A]))),0000)