Forum Discussion

ddalton's avatar
ddalton
Icon for Resolver I rankResolver I
4 years ago
Solved

Create new table column summing data from multiple tables

Hi,   I want to sum values by unique ID, and then add another value from a different table to those sums (based on the same unique ID) to create a new column in a table or create a new measure.   ...
Need Help
  • ddalton's avatar
    ddalton
    4 years ago

    Just now, I've tried:

     

    Table = SUMMARIZE(Table2,Table2[ID],"ValueC",SUM(Table2[ValueB]),"ValueA",SUMMARIZE(Table1,Table1[ValueA]))

     

    To create a new table, and then simple added a column in the table by adding the two columns together. 

     

    The added NewValue can then be referenced elsewhere.

ddalton's avatar
ddalton
Icon for Resolver I rankResolver I
4 years ago

Just now, I've tried:

 

Table = SUMMARIZE(Table2,Table2[ID],"ValueC",SUM(Table2[ValueB]),"ValueA",SUMMARIZE(Table1,Table1[ValueA]))

 

To create a new table, and then simple added a column in the table by adding the two columns together. 

 

The added NewValue can then be referenced elsewhere.