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.
Solved! Go to Solution.
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.
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.
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