Forum Discussion

NorthernGuy's avatar
NorthernGuy
Frequent Visitor
10 years ago
Solved

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.

 

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

     

     

     

     

     

     

     

     

     

    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.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

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

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

2 Replies

  • ankitpatira's avatar
    ankitpatira
    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.

     

     

     

     

     

     

     

     

     

    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.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

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