Forum Discussion

powax's avatar
powax
Regular Visitor
6 years ago
Solved

CONDITIONAL MULTIPLICATION ACROSS 2 TABELS

Hi, I am an amateur in Power BI but need to do something fairly complex. I need to derive estimated ingredient needs from budgeted product volumes. Each product can however be produced with severa...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    powax 

    The most simple way is you first create the "Ingredient per Budget" column in your Table1. 

    Ingredient per Budget = [Amount] * RELATED(Table2[Budget Volumne])
     
    Then create the result table: 
    Table = CALCULATETABLE(Table1,FILTER(Table1,Table1[Recipe]="recipe 11"||Table1[Recipe]="Recipe 21"))
     


    Community Support Team _ Paul Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more
Anonymous's avatar
Anonymous
Not applicable
6 years ago

powax 

The most simple way is you first create the "Ingredient per Budget" column in your Table1. 

Ingredient per Budget = [Amount] * RELATED(Table2[Budget Volumne])
 
Then create the result table: 
Table = CALCULATETABLE(Table1,FILTER(Table1,Table1[Recipe]="recipe 11"||Table1[Recipe]="Recipe 21"))
 


Community Support Team _ Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more