Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
SteveBrou
Frequent Visitor

Creating New Table from fields from 2 existing tables

I would like to create a new table using particular columns from an existing table 1 and an existing table 2. Some of these columns are the same fields in both table 1 and table 2 (e.g. First Name, Last Name, Target Start Date, and a few others). There are some columns in table 2 that are not contained in table 1. I would like to add these columns to the newly created table. The expected result would be that the rows brought over from table 2 would have information in this column and the rows already populated in the new table from table 1 would be blank. In addition, any rows that I bring over to the new table from table 1, I would like to filter based on a status field in table 1. Any rows that I bring over to the newly created table from table 2 I would also like to filter based on a status field contained in table 2. What is the best way for me to accomplish the above? Thanks in advance!!

2 REPLIES 2
harshnathani
Community Champion
Community Champion

Hi @SteveBrou ,

 

Please share sample of Table1, Table2 and expected output in text (not an image pls)

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

 

Regards,

HN

Table 1                                  Table 2

Job Title                                 Job Title

LCAT                                      First Name

First Name                             Last Name

Last Name                             Target Start Date

Target Start Date                   Subcontractor Name

 

Expected Output (New Table)

Job Title

FIrst Name

Last Name

Target Start Date

Subcontractor Name

 

Since the subcontractor name field only exists in table 2, the only rows that would have a value in subcontractor name column are those rows from table 2. The rows from table 1 would have no value in that column.

 

Thanks!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.