cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
felipeblanco
Frequent Visitor

Comparison Between Two Columns - Find Only Differences

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.

 

sccm.PNG cmdb.png

 

 

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.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

 

grafik.png

View solution in original post

3 REPLIES 3
felipeblanco
Frequent Visitor

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
Microsoft
Microsoft

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.Smiley Happy

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

 

Regards

Anonymous
Not applicable

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:

 

grafik.png

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.