Forum Discussion

arvindsj's avatar
arvindsj
Regular Visitor
5 years ago
Solved

Getting data from 2 different tables into single chart.

Hi,   Here is my requirement, I need some suggestions on how i can get this done.    I have 2 different table containing test executions data from 2 different tools. Although i can get 2 differen...
Need Help
  • arvindsj's avatar
    arvindsj
    5 years ago

    Hi,

     

    Here is what i did. Matched up columns of these 2 tables & used append as new to combine data into another table. This seem to work for me. 

     

    thanks for your suggestion.

     

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi arvindsj ,

 

Do two tables have the same structure？If so, you can try to append these two tables in one table: 

 

Please refer to https://radacad.com/append-vs-merge-in-power-bi-and-power-query  Or you can use bridge table and dax to show value from two table.  It all depends on what you need to show on visual.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

 

 

 

  • arvindsj's avatar
    arvindsj
    Regular Visitor
    5 years ago

    Hi,

     

    Here is what i did. Matched up columns of these 2 tables & used append as new to combine data into another table. This seem to work for me. 

     

    thanks for your suggestion.