How to compare two column with the same name with the different table in power bi.

Hey,

I created a new table "New Table" using this DAX statement:

New Table = 
DISTINCT(
    UNION(
        VALUES(Table1[Name])
        ,VALUES('Table2'[Name])
    )
)

Then I create a calculated column using this DAX statement:

Output = 
var thisName = 'New Table'[Name]
var tExist = INTERSECT(VALUES('Table1'[Name]), VALUES('Table2'[Name]))
var tMoveOut = EXCEPT(VALUES('Table1'[Name]), VALUES('Table2'[Name]))
var tNew = EXCEPT(VALUES('Table2'[Name]), VALUES('Table1'[Name]))
return
SWITCH(
    TRUE()
    ,thisName in tExist, "Exist"
    ,thisName in tMoveOut, "Move Out"
    ,thisName in tNew, "New"
    ,"this is odd"
)

After this the table New Table looks like this:

Hopefully this is what you are looking for.

Regards,

Tom