Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!!
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |