topic Re: Creating New Table from fields from 2 existing tables in DAX Commands and Tips

Creating New Table from fields from 2 existing tables

SteveBrou — Wed, 10 Jun 2020 23:07:05 GMT

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!!

Re: Creating New Table from fields from 2 existing tables

Anonymous — Thu, 11 Jun 2020 05:25:19 GMT

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,

Re: Creating New Table from fields from 2 existing tables

SteveBrou — Thu, 11 Jun 2020 22:14:12 GMT

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!