Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago
Solved

Calculating New Column

Hi There ;

 

İ have two table as below ,

 

Table A : Shows the quantity of stcok based on material code 

Table B : Shows the qunatity of orders based on material code and order numbers

 

i would like to create a column which is callin Added Quantity on Table A s below marked yellow. Just system will sum the quantities of materials from all order and will write to sum of quantitiy of material in this new column.As you see on Table B , sum of A material code is 30 , so in new column it is added 30 Qty.

 

 

 

 

Need Help
  • Shishir22's avatar
    Shishir22
    5 years ago

    Hello erhan_79 ,

     

    Give relationship between two tables between material code and use below DAX:

    Added Quantity = CALCULATE(SUM('Table B'[Quantity]))

     

    Please mark it as a solution if it fix the requirement.

     

    Thanks!

2 Replies

  • Shishir22's avatar
    Shishir22
    Solution Sage
    5 years ago

    Hello erhan_79 ,

     

    Give relationship between two tables between material code and use below DAX:

    Added Quantity = CALCULATE(SUM('Table B'[Quantity]))

     

    Please mark it as a solution if it fix the requirement.

     

    Thanks!