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.

     

amitchandak's avatar
amitchandak
Super User
5 years ago

arvindsj , You can create common tables like for Date or any other dimensions and use that to display data together :

 

Bridge Table : https://www.youtube.com/watch?v=Bkf35Roman8

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.