Forum Discussion
creating sales developement from quarterly reports(please help me :) )
Hey all ,
i could really use your help creating a quartly sales comparison.
i get from our system quarterly reports ( means i get on of only 01-03,2016 one of 01-06,2016 like that for each year.
i want to connect them all together and then show for example
sales devlopement of quarters 2016 something that sould look like that: (or insted of by country then by Products)
i have basically 4 different files for each year that looks like that (example ):
Country products description sales quantity
| germany | 1 | pro | 0 | 0 |
| germany | 2 | wow | 100 | 10 |
| germany | 3 | bla bla | 20 | 5 |
| germany | 4 | gdfg | 30 | 6 |
| germany | 5 | gg | 45 | 44 |
| France | 1 | pro | 22 | 33 |
| France | 2 | wow | 700 | 5 |
| France | 3 | bla bla | 400 | 22 |
| France | 4 | gdfg | 55 | 21 |
| France | 5 | gg | 123 | 44 |
| UK | 1 | gg | 475 | 754 |
| UK | 2 | bla bla | 2 | 5 |
| UK | 3 | pro | 575 | 44 |
Deos somebody know how can i do that / if its even possible ?
Thank you
Shahar
You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.
1 Reply
- v-chuncz-msft
Community Support
You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.