Forum Discussion

mariusz2022's avatar
mariusz2022
Frequent Visitor
4 years ago
Solved

Multiply two columns from different tables, duplicates

Hi, for several weeks I started my adventure with powerbi. I have problem when I want to multiply two columns from different tables and do the sum. Below are sample tables with the data:    ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mariusz2022 ,

     

    I suggest you to create a calculated column in "BOM" Table.

    Total Missing Qty = 
VAR _SUM = CALCULATE(SUM(BackOrders[Qty]))
RETURN
BOM[BOM_Qty] * _SUM

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • mariusz2022's avatar
    mariusz2022
    4 years ago

    Perfect is working, thanks.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mariusz2022 ,

 

I suggest you to create a calculated column in "BOM" Table.

Total Missing Qty = 
VAR _SUM = CALCULATE(SUM(BackOrders[Qty]))
RETURN
BOM[BOM_Qty] * _SUM

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

mariusz2022's avatar
mariusz2022
Frequent Visitor
4 years ago

Perfect is working, thanks.