Forum Discussion

sanjanarama's avatar
sanjanarama
Resolver I
4 years ago
Solved

multiple values in a column comparison

I have two tables as below with common attribute as ID. I wanted to compare names column from two tables if they match or not. Data in the columns are comma seperated values and can be present any...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi sanjanarama ,

     

    For this kind of output, judging by looping through the string may not be possible in powerbi. However, you can use a function like find to find out if the corresponding field exists in the list.

    1 = 
IFERROR ( FIND 
    ( "Apple", 
        Table1[parent Names] ), 
            BLANK () 
    )
    && 
    IFERROR ( FIND 
    ( "Orange", 
        Table1[parent Names] ),
             BLANK () )


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi sanjanarama ,

 

For this kind of output, judging by looping through the string may not be possible in powerbi. However, you can use a function like find to find out if the corresponding field exists in the list.

1 = 
IFERROR ( FIND 
    ( "Apple", 
        Table1[parent Names] ), 
            BLANK () 
    )
    && 
    IFERROR ( FIND 
    ( "Orange", 
        Table1[parent Names] ),
             BLANK () )


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.