power bi find all ids not in other tables code example
Example: power bi find all ids not in other tables
Difference Table = FILTER(Table1,NOT(CONTAINS(Table2,Table2[ID],Table1[ID])))
Difference Table = FILTER(Table1,NOT(CONTAINS(Table2,Table2[ID],Table1[ID])))