Compare two tables and return missing codes

Hello Anonymous, One way to achieve this is using merge queries in Power Query Editor. Merge your two tables based on the Code that exists on the both table. Once it is merged based on the key, click on keep nulls on the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023 table. It will give you the codes that doesn't exist on the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023 but exists on the MON_VG_20230723_000043_Full  table. I hope it helps! 

Thanks,

Abhinav