Forum Discussion

random_Bi_User's avatar
random_Bi_User
Frequent Visitor
4 years ago
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...
calculated column
DAX
Search
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi random_Bi_User 

    please try

    Calculated Column =
MAXX (
    FILTER (
        VALUES ( Products[Group] ),
        CONTAINSSTRING ( Table1[ddcolumn], Products[Group] )
    ),
    Products[Group]
)

     

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

random_Bi_User can you share sample tables so I could copy them to PBIX?

  • random_Bi_User's avatar
    random_Bi_User
    Frequent Visitor
    4 years ago

    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-1laptopLaptop
    SmatphonetestdataSmartphone
    1-y.2,LaptopasLaptop