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 Stev...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • NorthernGuy's avatar
    NorthernGuy
    Frequent Visitor
    10 years ago

    Thanks -- worked great.