Remove data from a file in another file automaticlly

Hi everyone,

Here is my problem, I have 2 files let's call them List 1 (all the data) and List 2 (specific data from list 1).

I was wondering if there is a DAX formula to automatically remove the rows from List 2 in List 1.

There's several columns but they are the same in both files

Thanks,

Nick.