Forum Discussion

felipeblanco's avatar
felipeblanco
Frequent Visitor
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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:

     

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

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

 

Regards