Forum Discussion
Multiple Sale Result by Second Table Values
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")
link: https://www.dropbox.com/s/wlpgrtig2nuynvl/Test.pbix?dl=0
In my master file Append_Direct Ohds_IAM&OES - i have month year split out...
Kindly just post the DAX not a new file, Please.
ref to Sale_Data_Master for the Calculated column Error
Hi, Anonymous
Without the source data connected, I cannot use Power Query to split MonthYear column and have Month-Full-Name in order to connect with Sale_Data_Master's Month Column.
Hold on ill Split the column and upload a new file....10 minutes
Hi, Anonymous
I think you deleted the error column in your Sales Data Master Table.
May I ask,
- Lookupvalue from "Which Table", and bring it to "Where" ??
- In AppendDirect Ohds table, the month name is Jan, Feb, Mar, ... but your Sales Data master Table has January, February, March, ... -> Can I create one more column to match the length of the name?
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.
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")