Calculating New Column

[erhan_79]

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.

[Shishir22 · Accepted solution]

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!

[erhan_79]

thanks @Shishir22 , it is working !