Forum Discussion

Pinky0404's avatar
Pinky0404
Helper III
8 years ago
Solved

Comparing two tables

Hi All,   I have 2 tables, Table 1 and Table 2 , Both has different structure and i am trying to find the  list of users  from table 2 who are not  in table 1. I have merged the tables, but unable ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Pinky0404

     

    There are a few ways you can do this.

     

    In DAX you can use the EXCEPT function to generate that as a list.

     

    https://msdn.microsoft.com/en-us/library/mt243784.aspx

     

    You can create this a as a calculated table if you prefer something like,

     

    New Table = 
 EXCEPT( SELECTCOLUMNS(TableA , "UserID" , [UserID]) ,
SELECTCOLUMNS(TableB , "UserID" , [UserID]) ,
)

    That approach will give you a list of Users that appear in TableA, but don't appear in TableB

     

    Otherwise try a Left outer join in Power Query.

     

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Pinky0404

 

There are a few ways you can do this.

 

In DAX you can use the EXCEPT function to generate that as a list.

 

https://msdn.microsoft.com/en-us/library/mt243784.aspx

 

You can create this a as a calculated table if you prefer something like,

 

New Table = 
 EXCEPT( SELECTCOLUMNS(TableA , "UserID" , [UserID]) ,
SELECTCOLUMNS(TableB , "UserID" , [UserID]) ,
)

That approach will give you a list of Users that appear in TableA, but don't appear in TableB

 

Otherwise try a Left outer join in Power Query.