cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 self. 

 

For example: 


I have an imported database table that includes numbers that are related to certain WAN Interfaces. However I want to create a table that includes the numbers but has them listed with more user friendly names as opposed to the long name that is included in the database. I want these numbers to update when I press refress and be related to the original Database Table so that they update. 

 

How can I do this? 

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Using Data from One Table in Another Table

@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,

View solution in original post

4 REPLIES 4
Highlighted
Community Champion
Community Champion

Re: Using Data from One Table in Another Table

@marisap You can do this by going to query editor in power bi desktop, right click your original table query and click Reference. Then add conditional columns to new created queries and when you hit refresh your original table will be refreshed and so will be the table with reference query.

Highlighted
Regular Visitor

Re: Using Data from One Table in Another Table

Thank you!!

Highlighted
Microsoft
Microsoft

Re: Using Data from One Table in Another Table

@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,

View solution in original post

Highlighted
Regular Visitor

Re: Using Data from One Table in Another Table

THANK YOU

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors