Forum Discussion
felipeblanco
9 years agoFrequent 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...
- Anonymous9 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:
felipeblanco
9 years agoFrequent Visitor
Thanks everyone for the assistance! I tested both solutions and they worked.
The first one was that better fits my needs.
Best Regards!