Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I need to check which codes(CPF) are missing in the MON_VG_20230723_000043_Full table, when I compare it with the Snapshot_Beneficiarios_Corte202307_Carga202307_16082023-102500 table.
The result should be a list of the codes that are missing from the MON_VG_20230723_000043_Full table
Solved! Go to Solution.
Hello @edumach, 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
Hello @edumach, 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
@mussaenda This is just a sampling, there are many codes, the table has 1.5 million records
Hi @edumach ,
I understand. That is hy you need a masterlist of your codes.
You can append the codes as new table and remove the duplicates the use it as your lookup table.
This just one of the ways.
Hi @edumach ,
my suggestion is to have a masterlist of all the codes and then you can lookup the values
from your provided data, the missing codes are ...0006 and ...0007, right?