cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EnsFlynn Frequent Visitor
Frequent Visitor

RELATED() not working properly, despite Many to 1 relationship

I'm trying to create a column in a table that is based on the value of two other columns. In both tables I have created a column that is just the two columns concatenated so as to make a composite key I can use for a Many:1 relationship. I have set up the relationship successfully and it is active as a Many:1, yet when I try to use RELATED in a new column for the Many table, it says that it either doesn't exist or has no relationship to any table in the context

 

related bug.PNG

 

NewTargets is the 1 table in the 1:Many, and the related by a column CompKey. I'm completely stumped as to why the RELATED function doesn't work here

1 ACCEPTED SOLUTION

Accepted Solutions
EnsFlynn Frequent Visitor
Frequent Visitor

Re: RELATED() not working properly, despite Many to 1 relationship

Ok well I managed to fix my problem soon after posting this. For some reason I was under the impression that RELATED required a 1:many or Many:1 relationship, when it actually needs a 1:1 relationship. 1:Many relationships should be handles by RELATEDTABLE and used as input tables for expressions (in my case I used MAXX).

1 REPLY 1
EnsFlynn Frequent Visitor
Frequent Visitor

Re: RELATED() not working properly, despite Many to 1 relationship

Ok well I managed to fix my problem soon after posting this. For some reason I was under the impression that RELATED required a 1:many or Many:1 relationship, when it actually needs a 1:1 relationship. 1:Many relationships should be handles by RELATEDTABLE and used as input tables for expressions (in my case I used MAXX).

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 45 members 1,216 guests
Please welcome our newest community members: