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

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi random_Bi_User 

please try

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

 

random_Bi_User's avatar
random_Bi_User
Frequent Visitor
4 years ago

Thank you very much tamerj1 it worked perfectly!