Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

add different columns from different tables without using sum function

hi Team,   I have 2 different tables  Table1  ID   Jun:A   Jul:A   Aug:A   123                    5,643                    9,876                    5,820                  456     ...
Need Help
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

if it's calculated column in Table2 this should work

RELATED(Table1[Jun:A])+Table2[Jul:F]+Table2[Aug:F]

in Table1 this should work

Table1[Jun:A])+RELATED(Table2[Jul:F])+RELATED(Table2[Aug:F])