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   ...
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!

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!

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago

thanks Shishir22 , it is working !