Forum Discussion

goldenfisherman's avatar
goldenfisherman
Frequent Visitor
2 years ago

Condition column includes multiple values in one cell

I've included a DAX function in data model, which labels Company Name based on Company ID found in another column (namely Relationship a referenced column). Within this Relationship column, there cou...
Need Help
goldenfisherman's avatar
goldenfisherman
Frequent Visitor
2 years ago

Hi Anonymous thanks for providing solution.

 

I am still trying to understand the query you have, looks like you have to create a lookup table which is customer id and then use that as a lookup value for another query? I still don't know how it will apply to my case. For example, for the below table, what I want to achieve is for the Company Name column, I want to be able to have the company name assigned based on the company ID in the Relationship column. Currently I use DAX containsstring which only assign one company name for each cell although there could be multiple company ID in the relationship company column. Any ideas how to go about this?

 

Relationship CompanyCompany Name
1Etsy
1,2 ,3Etsy, Amazon, Apple
3,4,5Apple, Oatly, Ford
2,3,6Amazon, Apple, Toyota
1,2,3,4,5,6Etsy, Amazon, Apple, Oatly, Ford, Toyota

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi goldenfisherman 

How would you like to find the company name? Is your company ID column and company name column in the same table, the data you provided may seem incomplete, can you provide some more detailed example data?

 

Best Regards!

Yolo Zhu