Compare two tables and display missing rows from the first table

[Anonymous]

Hi Folks,

I am facing a challenge. I have two different tables that have hundreds of rows in them. These two tables are connected by a common column(Name). I want to compare two tables on the attribute name and then display the rows of table-1 which are not present in Table-2. It would be great if anyone can help me in this regard:
My data looks like this

          

[amitchandak · Accepted solution]

@Anonymous , Create a new table like

New table =
var _tab = except(all(Table1[Name]),all(Table2[Name]))
return
calculatetable(Table1, filter(Table1, Table1[Name] in _tab))

[Anonymous]

@amitchandak The new table we have created is working well when the data is stable. But in my case, Table 1 has live data & it changes every few seconds. Table 2 is updated once a day. So I need to keep comparing the two tables and keep changing the rows in the new table very frequently(every few seconds). Is this possible?

[Anonymous]

Thank you so much for your quick help @amitchandak