Forum Discussion

Qualube's avatar
Qualube
Helper II
8 years ago
Solved

Adding Values from Columns in different tables

Hi

 

I am very new to Power BI but I need to calculate the total value from columns on different tables which do have a relationship.

The first table shows the quantity and item code and the second table shows the weight.

However I need the totals for each type of material, I have ried SUMX to try and go through each row and arrive at the right total but can't seem to make it work.

Below is the table with the Quantity, Pack Size & Material the other table just holds the packs size & weight.

 

Many Thanks

 

QuantityPack SizeItem Group

Material

2202 Pack Paints (non isocyanate)Plastic
420-4482 Pack Paints (non isocyanate)Metal
2652 Pack Paints (non isocyanate)Plastic
25-2202 Pack Paints (non isocyanate)Metal
275-4212 Pack Paints (non isocyanate)Metal
7755-6082 Pack Paints (non isocyanate)Metal
121Agricultural FluidsPlastic
31-GP1Agricultural FluidsPlastic
Need Help
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    Hi Qualube,

    Merge the 2 tables by Pack Size. Now both the Quantity and Weight will be present in the same table.

     

    Now you can multiple the columns Quantity and Weight just like a simple Multiplication

     

    Hope this helps!!

     

    Click here for the sample PBI

2 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Hi Qualube,

    Merge the 2 tables by Pack Size. Now both the Quantity and Weight will be present in the same table.

     

    Now you can multiple the columns Quantity and Weight just like a simple Multiplication

     

    Hope this helps!!

     

    Click here for the sample PBI

    • Qualube's avatar
      Qualube
      Helper II
      8 years ago

      Hi Thejeswar

       

      Worked a treat thanks appreciate the help.

       

      Thanks