Forum Discussion
Linking multiple tables using multiple criteria
Hello, Please see the image below. I have 3 tables. I'd like to summarize the results data from tables 2 and 3 into a matrix at the bottom. Table1 contains identifying info with the ID, N...
amitchandak
Super User
Super UserAnonymous , You have column in table 1 like
result 2=
sumx(Filter(Table2, Table2[ID] = Table1[ID] && Table2[month] = Table1[month]), Table2[Result])
result 3=
sumx(Filter(Table3, Table3[ID] = Table1[ID] && Table3[month] = Table1[month]), Table2[Result])
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