How to pick up one exact string among many in same cell

[Anonymous]

Factory	Product	Result
Asia	Product A, Product AB, Product ABC, Product ABCD	Product AB
Europe	Product AB, Product ABCD	Product AB
NA	Product ABC, Product ABCD	null

Hello,

Just wondering is this trivial issue, but I need to pick up exact string from one cell.

The result that I want in this example is in column Result - looking for Product AB from Product column.

What is the easiest way to do this ? With Conditional Column I can't do this.

Thanks. 

[Anonymous]

The best way to tackle this, though, would be to use the split-on-delimiter functionality in Power Query so that each product is on its own line. Then it's really trivial to find the rows where the string you want is embedded.

[Anonymous]

What does it mean you can't do this with a conditional column? Do you want to have a calculated column in a model table? If so, then it's easy. Use the function that will return True if the string in Product contains the string you want and False otherwise. Then use If(...) to turn True into the string of your choosing. That's rather simple, isn't it? This is the function to use: https://docs.microsoft.com/en-us/dax/containsstring-function-dax