Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multiplying two columns in two different tables

Hello everyone,

 

I need to get DLP current $ and DLP historic $ based on Order qty. So I need to mulitply DLP current and historic by the ORDER QTY. I've been trying many multiplication dax queries but they don't seem to be seeing the relationship based on SKU. 

 

I am needing to update the products with MY23 prices so that's why SKU_D has SKU, then DLP_current and DLP_historic. 

 

I am trying to match the existing ORDER QTY by SKU and then Multiplying them by DLP_Current and DLP_Historic 

 

I am suspecting there is something wrong with my data modeln t

 

Thank you,

 

 

 

Need Help

3 Replies

  • danextian's avatar
    danextian
    Super User
    3 years ago

    Hi Anonymous ,

     

    The  proposed formula below is solely based on the information provided. As I don't have a sample data model and don't know what result to expect, this may or may not yield the desired result.

    total =
SUMX (
    VALUES ( Early_Pricing[SKU] ),
    SUM ( SKU_D[dip_current] ) * SUM ( early_order_sub[Order Qty] )
)

    change the column to dip_historic to get the total for historic

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello danextian 

       

      Thank you for responding. I am creating a Product Matrix table so the correct DAX function should allow me to see DLP current & DLP Historic for Product A, Product B, etc.

       

      The dax query doesn't work at the moment as I am seeing a sum of all ORDER QTY * by the sum of DLP_current.