Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple Sale Result by Second Table Values

Hi  Experts   Here is the first question which gives me the correct answer for the first part.  link: https://community.powerbi.com/t5/Desktop/Calculate-Sales-by-Channel-by-Region-by-County-by-Mon...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    I am not sure if the below works.

     

    LookupCost = LOOKUPVALUE( 'Append_Direct Ohds_IAM&OES'[Value], 'Append_Direct Ohds_IAM&OES'[Month], Sales_Data_Master[MonthV2], 'Append_Direct Ohds_IAM&OES'[Year], Sales_Data_Master[Years_In_Date], 'Append_Direct Ohds_IAM&OES'[Channel], Sales_Data_Master[Channel], 'Append_Direct Ohds_IAM&OES'[Country], Sales_Data_Master[Sales_Country], 'Append_Direct Ohds_IAM&OES'[Type of Cost], "4.Purch")
AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Anonymous  Why are you needing this as a calculated column? If you create it as a measure it will use the context of the table you put it in, and when you slice by Month-Year from your DimDate table (assuming you have one???) then it will automatically pull the correct Value from both tables. 

 

Can you share a screenshot of your relationships please?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Allison - firstly thanks for looking at my question. I'll share a file later on today. Need to strip out sensitive data.