Forum Discussion

jps_HHH's avatar
jps_HHH
Helper II
1 year ago
Solved

Merge count from two different tables

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 ?  

Need Help
  • Deku's avatar
    Deku
    1 year ago

    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

2 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

    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

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    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.