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

Create table of merged columns

Hi,

 

I'm working on a graph of bookings by sales person -- I have a table of 2015 data and a table of 2016 data.  

 

Table 1 - 2015

Sales Person      Amount

John                   $4,000

Steve                  $5,000

John                   $2,300

Alex                    $1,500

 

Table 2 - 2016

Sales Person      Amount

John                   $4,000

Katie                   $3,900

Steve                  $5,000

Larry                   $2,000

Steve                  $2,300

 

 

I need to create a list of the unique sales people in a new table.

 

Table 3 - New with all sales people from 2015 & 2016

John

Katie

Steve

Larry

Alex

 

Thanks.

 

1 ACCEPTED SOLUTION
Community Champion
Community Champion

@NorthernGuy This question should be posted in desktop forum. In power bi desktop go to query editor, under Home tab click Enter Data, Name as 'Merged' and click OK.

 

Capture.PNG

 

 

 

 

 

 

 

 

Then select new created table and under Home tab, under Combine, click Append Queries, Three or more tables, add previous two tables and click OK. This should give you table as below.

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Then for Merged table remove Column1, Amount, highlight SalesPerson column and click Remove Duplicates.

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

View solution in original post

2 REPLIES 2
Community Champion
Community Champion

@NorthernGuy This question should be posted in desktop forum. In power bi desktop go to query editor, under Home tab click Enter Data, Name as 'Merged' and click OK.

 

Capture.PNG

 

 

 

 

 

 

 

 

Then select new created table and under Home tab, under Combine, click Append Queries, Three or more tables, add previous two tables and click OK. This should give you table as below.

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Then for Merged table remove Column1, Amount, highlight SalesPerson column and click Remove Duplicates.

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

View solution in original post

Thanks -- worked great.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

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

Top Solution Authors
Top Kudoed Authors