union 2 tables with date condition

Hi, pani_victoria 

Thanks for DAX_Machine  and ryan_mayu reply. If you have not find the suitable dax, you can try this.

NewTable = 
FILTER(
    'Table 2',
    NOT('Table 2'[Date] IN VALUES('Table 1'[Date]))
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum