Forum Discussion

Qualube's avatar
Qualube
Icon for Helper II rankHelper 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 secon...
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

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper 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
Icon for Helper II rankHelper II
8 years ago

Hi Thejeswar

 

Worked a treat thanks appreciate the help.

 

Thanks