Forum Discussion
Creating a new table with a column that is the elementwise sum of columns from two other tables
My question seems like a relatively simple one, but I haven't been able to find any answer on this forum that satisfies me. Table A contains a column of company names and a column of values for t...
Anonymous the best approach here is to create a company dimension with unique list of companies, set relationship with this company table with you revenue and cost tables
Add following measures
Revenue = SUM(RevenueTable[Revenue]) Cost = SUM( CostTable[Cost] )
Diff = [Revenue] - [Cost]add table visual, and put company from newly create company table, and all above measures.
