cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joschultz Member
Member

2014 and 2015 sales data

 

 

how can I combine sales data from 2014 and 2015 in a line graph to show year over year if they are in two seperate data sets?  I have then seperated becuase the files are so large.

 

Thank you,

 

Joseph

1 ACCEPTED SOLUTION

Accepted Solutions
MaryF Regular Visitor
Regular Visitor

Re: 2014 and 2015 sales data

Have you come across Append within the Query Editor? This allows you to create one table from both sheets, its very intuitive to use. Hope this helps

 

 

7 REPLIES 7
elliotdixon Member
Member

Re: 2014 and 2015 sales data

Hi @joschultz

 

If in two tables you might need to combine them together first. is it two SQL tables or excel sheets?

joschultz Member
Member

Re: 2014 and 2015 sales data

They are excel sheets..  they have the same fields just one is 2014 data and one is 2015 data.  I tried to create a relationship between the two with the date but that wasnt working for me.

MaryF Regular Visitor
Regular Visitor

Re: 2014 and 2015 sales data

Have you come across Append within the Query Editor? This allows you to create one table from both sheets, its very intuitive to use. Hope this helps

 

 

itchyeyeballs Established Member
Established Member

Re: 2014 and 2015 sales data

As stated above, combine the files.

 

File size is not really an issue as it is with Excel. Power Pivot & Power BI can cope with tens of millions of rows so unless you are analysing 2014 vs 2015 for Amazon you should have no problem.

joschultz Member
Member

Re: 2014 and 2015 sales data

I have been trying to figure that out for awhile!  The append worked great!!!!  Can you append more than one data source?  Say if I wanted to keep my data a month at a time?

itchyeyeballs Established Member
Established Member

Re: 2014 and 2015 sales data

Yes as long as the structure of the sources is consistent.

 

If all your data is saved in seperate (consistent) spreadsheets you can bulk import so your data will update by just presing refresh - http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/

(this examaple is excel but should wiork the same)

 

If your data originates in a database you could skip the excel spreadsheets altogether and import direct

Highlighted
elliotdixon Member
Member

Re: 2014 and 2015 sales data

@itchyeyeballs is on to it
here is a great video about using Power Query to suck the two excel files into one datamodel or one excel sheet
https://youtu.be/a7E29H5ZUmE

By Excel Is Fun

Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model