Creating a new table in Power BI

[kwonder]

Hello,

I'm new to the Power BI Desktop and I'm trying to create a new table that will have columns from the multiple tables I pulled in from my source. Could someone please help me with this? Example: I have a course table and Instructor table I need to bring certain columns from each table.

[Anonymous]

Hi @kwonder,

   if your tables have a relationship between them you can use the NATURALINNERJOIN function() or the NATURALLEFTOUTERJOIN function(). Something like:

New Table = NATURALINNERJOIN(Course;Instructor)

or

New Table = NATURALLEFTOUTERJOIN(Course;Instructor)

Or if you want something different you can use the query editor mode and "merge queries".

Let me know if it works.

#I'M Not An Expert#

[Rémi]

Hi,

It will be difficult to explain to you all that things.

Try to read this guide and to follow it, then if you have questions, come back here 🙂

[coreyw]

I 'tried' following through the guide that you suggested and this appears to be a topic that is beyond that getting started set of pages.