Forum Discussion

cdfisher89's avatar
cdfisher89
Frequent Visitor
9 years ago
Solved

Sum from related table

  I am trying to sum values that are on other tables onto a master table, but I can't seem to get it to work.  It is essentially a Sumif function, but I can't seem to get Calculate and or SUMX to wo...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Try:

    AssignmentTable[Total Fee] = CALCULATE(SUM(Revenue[Fee]))

     

    The calculate is weird and required.

Dan80's avatar
Dan80
Icon for Helper II rankHelper II
9 years ago

Best to use power query/query editor then bring the data through in one table. 

 

Start with 'group by' function which is basically a sumif and do this for both the revenue table and the time table. This will produce one summed up value for each assignment. Then merge the time table into the revenue table, linking them by the assignment, select the hours colum to bring through to the revenue table. This will produce what you need 3 rows and 2 columns of data. Boom!