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 querie...
Need Help
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.