Forum Discussion
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...
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:
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: