weekly sales report by product accross multipul locations

[joel1201]

Hi All

This is my first adventure into the Power Bi Land and despite going though the tutorials it is just not clicking for me.

I'm trying to build a sales report that colates week on week sales based on certain products.

REPORT Table

PLU	Description	W1Qty Sold	W1$Sold	W2Qty Sold	W2$Sold
123	Product 1	500	5000	400	4000
555	Product 2	90	900	50	500

Data for each week is in a seperate sheet

PLU	Description	Store	Qty Sold	$ Sold
123	Product 1	Store1	700	7000
123	Product 1	Store2	500	5000
555	Product 2	Store1	80	800
555	Product 2	Store2	50	500

Additionally I am only looking for certain products in the lists, these are listed in another table 

PLU	Description	Size	Category
123	Product 1	425	BT-425
500	Product 2	425	BT-425
325	Product 3	570	BT-570
999	Product 4	30	Spirits

Any help or a point in the right direction would be very much appreciated.

Thanks

Joel

[parry2k · Accepted solution]

@joel1201 the best would be combine each weekly sales report in one table, you can do this in power query (advanced editor) append feature, before appending add new column in your file called "Week" and assign value to "Week 1", "week 2", depending on fiile.

At end, you will have file of all weeks with a column "Week" showing which week this file is from, and now if you use matrix visual, you can have product on rows, week on column and $ and qty on values. and everything will line up.