Forum Discussion
Related not working while m:m relationship
Hi Team,
I am trying to create a calculate column by using Related but it shows me below error.I already have a relationship between these 2 columns itemname:
Thanks,
nj
Anonymous , related will work only from 1 to Many side
you can try
sumx(relatedtable(Sales), Sales[Sales])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
1 Reply
- amitchandak
Super User
Anonymous , related will work only from 1 to Many side
you can try
sumx(relatedtable(Sales), Sales[Sales])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8