Forum Discussion
SUM RELATED
Hello, I have 2 tables with a many to many relationship. I need to sum the costs from table 1 but filter based on the other table. The RELATED function doesnt work for me because of the many to man...
Anonymous , You need to use relatedtable in sumx
new column in table 1 =
sumx(relatedtable(Table2), Table2[Value])
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