Forum Discussion

Ricardo77's avatar
Ricardo77
Helper II
4 years ago
Solved

Find columns from one table in another table

Hello, i'm trying to find columns of 1 table on a 2nd table, but i'm struggling because i can't seem to use distinct or values with text operators (2nd column can be slightly different, as you'll se...
Tip
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Then use

     

    =
SUMX (
    VALUES ( table1[Column1] ),
    IF (
        SUMX (
            VALUES ( table2[Column1] ),
            IF ( CONTAINSSTRING ( table2[Column1], table1[Column1] ), 1 )
        ) > 0,
        1
    )
)

     

Ricardo77's avatar
Ricardo77
Helper II
4 years ago

Thanks for your help tamerj1 , it seems OK in my real PBIx, by some reason in the PBI POC i created, with the 2 tables directly created in PBI, i was getting that message error.