Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Comparing 3 columns in 3 different tables

Hi,   I have 3 tables and each of them has a "Name" column titled Name1, Name2 and Name3, respectively. All three columns contain device numbers.    I'm trying to find the device numbers that do ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Try this calculated table>>from the modelling tab>>New Table

     

    Calc Table =
VAR DevicesInAllTables =
    INTERSECT (
        INTERSECT ( VALUES ( Table1[Name1] ), VALUES ( Table2[Name2] ) ),
        VALUES ( Table3[Name3] )
    )
RETURN
    EXCEPT (
        DISTINCT (
            UNION (
                VALUES ( Table1[Name1] ),
                VALUES ( Table2[Name2] ),
                VALUES ( Table3[Name3] )
            )
        ),
        DevicesInAllTables
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous 

 

you can use soemthing like this.

Please see attached file as well

 

 

Column =
VAR temp =
    {
        IF ( ISEMPTY ( FILTER ( Table1, Table1[Name1] = CalcTable[Name1] ) ), "Name1" ),
        IF ( ISEMPTY ( FILTER ( Table2, Table2[Name2] = CalcTable[Name1] ) ), "Name2" ),
        IF ( ISEMPTY ( FILTER ( Table3, Table3[Name3] = CalcTable[Name1] ) ), "Name3" )
    }
RETURN
    CONCATENATEX ( FILTER ( temp, [Value] <> BLANK () ), [Value], ",", [Value] )

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Amazing, you're a star. Thank you.