Comparison Between Two Columns - Find Only Differences

[felipeblanco]

Hello Everyone, 

I have a PowerBI local dashboard that provides to me a inventory accuracy report based in two databases provided by 2 IT System in my company. The main propurse of this report is to normalize and make both system be more equal as it's possible.

 

One of the most important functions should be compare these two databases and find the missing assets in one of the bases (CMDB), so we can add them basead on the information from the other database (SCCM). 

How is the best way to compare two columns and find only the itens that are not on the other database?

Thanks in advance for your help.

[felipeblanco]

Thanks everyone for the assistance! I tested both solutions and they worked.

The first one was that better fits my needs.

Best Regards!

[v-ljerr-msft]

Hi @felipeblanco,

According to your description above, I would suggest you use CONTAINS Function (DAX) to create a new calculate column in your SCCM table to flag if the current row value is contained in CMDB table. The formula below is for your reference.

IsContainedInCMDB = CONTAINS ( 'CMDB', 'CMDB'[Column1], 'SCCM'[Column1] )

Regards

[Anonymous · Accepted solution]

Hi @felipeblanco

Assuming that you have an identical structure for every CI in both CMDB and SCCM and that every CI has an unique identifier,

you can MERGE the two queries aka tables by using the CI as matching column.

The result is new table: