Forum Discussion
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...
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")
Hi Kim yes...you can and I want to lookup value in AppendDirect Ohds table..just tell me what to do and I'll follow your steps. Don't post another pbix.
Where to sale data master.
Jihwan_Kim
Super User
Super UserHi, 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")
What results did you get?
- Jihwan_Kim
I got all 0.
I don't think it is correct.
😓
thank you sir