Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
Hi @joschultz
If in two tables you might need to combine them together first. is it two SQL tables or excel sheets?
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.
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
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?
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
@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
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |