I am wanting to sum the the columns from two table into a new column in a third table. I have to make sure that it only sums the data matching in both tables from two other columns.
if 'tEE'[Sold to Party] is equal to 'External Revenue'[Sold to] , if 'tEE[Material] is equal to 'External Revenue'[Generic Material] and if 'IAS'[Sold to Party] is equal to 'Exernal Revenue'[Sold to], if 'IAS'[Eqpt] is equal to 'External Revenue'[Generic Material] then sum the 'tEE[month]+'IAS[month] in a new column in the External Revenue table.
|Table : External Revenue|
|Sold To||Generic Material|
|Table : tEE|
|Sold to Pary||Material||Month|
|Sold to Pary||Eqpt||Month|
Result of what new column should look like:
|Table External Revenue|
|Sold To||Generic Material||Inbound FY|
I hope that makes sense. Thank you in advance for your help.
Solved! Go to Solution.
Please find the code
Thank you for your response.
I am very very new to power bi and so have a few questions if you dont mind.
have new tables been created for these two steps: