Forum Discussion
Solved
Search All Column Values in a different Column
Hi All! I have a column with dirty data - lets call it ddColumn. Some of the Rows in the ddColumn contain product groups. I would like to have a calculated column with the name of the product g...
please try
Calculated Column = MAXX ( FILTER ( VALUES ( Products[Group] ), CONTAINSSTRING ( Table1[ddcolumn], Products[Group] ) ), Products[Group] )
random_Bi_User can you share sample tables so I could copy them to PBIX?
Thanks alot SpartaBI for your answer.
Is this enough or do you need more data?
Table1:
ddColumn
| abcdSmartphone_content |
| content2022share |
| .1-1laptop |
| Smatphonetestdata |
| 1-y.2,laptopas |
product details table:
product group
| Smartphone |
| Tablet |
| Laptop |
| Camera |
desired output:
Table1:
ddColumn Calculated Column
| abcdSmartphone_content | Smartphone |
| content2022share | |
| .1-1laptop | Laptop |
| Smatphonetestdata | Smartphone |
| 1-y.2,Laptopas | Laptop |