Forum Discussion

marisap's avatar
marisap
Regular Visitor
10 years ago
Solved

Using Data from One Table in Another Table

Hi There,    I want to copy data from an imported Database Table and create a new table that includes the data from the imported table as well as additional columns that I would like to create my s...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    marisap

     

    In this scenario, you should have linked column between those two tables. Then you can go to Query Editor and use "Merge Queries" to combine the tables together. See: Shape and combine data in Power BI Desktop

     

    Another way is using DAX method. If you have built the relationships between these two tables, you can use RELATED() function to JOIN tables. Without relationship built, you can also use LOOKUPVALUE() to lookup that columns you need. For more information, please see: From SQL to DAX: Joining Tables.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

marisap

 

In this scenario, you should have linked column between those two tables. Then you can go to Query Editor and use "Merge Queries" to combine the tables together. See: Shape and combine data in Power BI Desktop

 

Another way is using DAX method. If you have built the relationships between these two tables, you can use RELATED() function to JOIN tables. Without relationship built, you can also use LOOKUPVALUE() to lookup that columns you need. For more information, please see: From SQL to DAX: Joining Tables.

 

Regards,