Lookup that will compare Table 1 & Table 2 and add field to Table 1 with results

[EZimmet]

Thank you all for the assistance.

I need to do a Lookup that will compare two Tables

1.  If a record is found in both Tables I need it to show in Table 1 with a status of " Found "
2.  If a record is not found in Table 1 but resides in Table 2 I need it added to Table 1 with a comment " ADDED "

[amitchandak · Accepted solution]

@EZimmet , You can use one of the 4 methods

 refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[amitchandak · Accepted solution]

@EZimmet , You can use one of the 4 methods

 refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[EZimmet · Accepted solution]

The data shows under the Data Model -- Not Showing under the Transformation Data Screen ?

Can someone assist in converting a DAX 

Findme = LOOKUPVALUE('Staff_to_Site_Team'[CreatedBy],'Staff_to_Site_Team'[CreatedBy],'Profile without Group'[CreatedBy])

into a M Query