Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Good day
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.
Therefore:
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 |
25000652 | 4055 |
25000778 | 3 |
25000342 | 1 |
25000742 | 3 |
25000421 | 1 |
Table : tEE | ||
Sold to Pary | Material | Month |
25000342 | 1 | 25.00 |
25000742 | 3 | 32.50 |
25000652 | 4055 | 44.50 |
25000421 | 1 | 30.00 |
25000778 | 3 | 15.00 |
Table IAS | ||
Sold to Pary | Eqpt | Month |
25000342 | 1 | 42.00 |
25000742 | 3 | 15.00 |
25000652 | 4055 | 33.40 |
25000421 | 1 | 15.35 |
25000778 | 3 | 55.00 |
Result of what new column should look like:
Table External Revenue | ||
Sold To | Generic Material | Inbound FY |
25000652 | 4055 | 77.90 |
25000778 | 3 | 70.00 |
25000342 | 1 | 67.00 |
25000742 | 3 | 47.50 |
25000421 | 1 | 45.35 |
I hope that makes sense. Thank you in advance for your help.
Solved! Go to Solution.
o this is variable to store the fields values. After you can use it as criteria in a measure
o this is variable to store the fields values. After you can use it as criteria in a measure
Please could you advise how you calculate the fields value for the variable if you dont mind. thank you
HI
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:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!