Displaying a summation of data by week of month and feild

[Anonymous]

I have a data table in a sharepoint list. It contains three columns: 1) Name 2) Date 3) Quantity of fruit purchased

I want to sum the quanity of fruit purchased by each person in a given given week. i would then want to display it like the following. Whats the best way to do it? 

	January	January	January	January
	Week 1 (1st- 7th)	Week 2 (8th-14th)	Week 3 (15-21)	Week 4 (22-29th)
Person A	100,000	0	3	0
Person B	0	2	400,000	0
Person C	5,000	0	1	0

	Feb	Feb	Feb	Feb
	Week 1 (30th Jan- 5th)	Week 2 (8th-14th)	Week 3 (15-21)	Week 4 (22-29th)
Person A	100,000	0	3	0
Person B	0	2	400,000	0
Person C	5,000	0	1	0

So on and so forth.

I have a Matrix table that show by year, quater, month and date. But I would need standalone tables that can disolay it like above. 

[lbendlin]

Use a calendar table in your data model.  Most likely you want to maintain that outside of Power BI to accomodate your special week mapping logic.