Forum Discussion
Issue with relationship
Hi, I'm not sure why I can't use relate function to one of my tables. Basically everything looks good between the relationship. This is the context: In table "interaction_source" I need to create a column to bring the "task" column in "Interactive_Related" table, so I'm using.
Related task = RELATED(Interactive_Related[task])
This is because I need to count blank values that will come in interaction_source new column, that's why this is a *:1.
I notice that when I type the Related function it's not populating the options of the related table, indicating some issue on the relationship. Can someone help to find out why it's getting this issue??
if you are creating a column in the table at the many side of the relationship, use RELATED
if you are creating a colum in the table at the one side of the relationship , you should use relatedtable .
NB : relatedtable returns a table , so you need to use relatedtable with an iterator or countrows() etc.. .
let me know if that works for you .
If this answers your question , mark it as the solution ā so can you can help other people in the community find it easily .
1 Reply
if you are creating a column in the table at the many side of the relationship, use RELATED
if you are creating a colum in the table at the one side of the relationship , you should use relatedtable .
NB : relatedtable returns a table , so you need to use relatedtable with an iterator or countrows() etc.. .
let me know if that works for you .
If this answers your question , mark it as the solution ā so can you can help other people in the community find it easily .