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
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

 

goldenfisherman's avatar
goldenfisherman
Frequent Visitor
2 years ago

hi Anonymous  yes. the company ID column and company name column should be the same table. Basically, I want to create a calculated "Company Name" column which multiple conditions based on the company ID column, however, if the containsstring I currently have, it only give one value (company name) in each cell. Meanwhile, in the company ID column, there could be multiple IDs. For example, 1,2,3 or 3,5,6, I want the campany name column to have Etsy,Amazon,Apple or Apple, Ford, Toyota instead of just one company name.

 

Thanks so much for your help!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi goldenfisherman 

    Can you provide some sample data so that can provide more suggestion for you

     

    Best Regards!

    Yolo Zhu