Multiplying two columns in two different tables

[Anonymous]

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,

[danextian]

Can you please post a sanitized data model/pbix?

Here's how you can get a better response. https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump... 

[danextian]

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]

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.