Merge count from two different tables

[jps_HHH]

Hi all,

I have a PBI file connected to two different databases. 

However, this databases are similar columns but one database is filled in by mechanics and other by quality control.

For instance:

Database 1:  Columns "Part Number"  "Fail Description" 

Database 2:  Columns "Part Number"  "Fail Description"  

The information is not duplicated. IF a mechanic observes a fail, record it. But if a quality person observes a fail reported too.

I would like to put a graph with the "part Number" with more fails and a table with the Part number and the description.

I think that I should create a new column that includes all lines from database 1 and 2. Is that right ?  

[v-venuppu]

Hi @jps_HHH ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[Deku · Accepted solution]

I would union the table. So you would have something like

• PartNumber
• FailureReportDate
• FailureReportingSource
• Description

Then can easily sum\count and slice by the identifier of the failure