Matrix view with weekend going across

[learner03]

I have this below table-

I need to have the view as matrix or table with summarised by Category,column with Stock on hand, committed and then based on the weekend date of the Stock due date, i need the weekend going across with the values of Due Qty feeding in as per weekend.

After that when you drill through any category, we are directed with same view but product id and subcategory-wise.

@bolfri  @amitchandak 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). As a Super User you can attach the files here directly.
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[learner03]

@lbendlin 

The input table-

Product ID	category	Sub category	StockDue Date	Due QTY	On Hand	Committed
1	Bed	bedsheet	1/03/2023	20	19	21
2	Pillow	Pillowcover	8/03/2023	42	23	32
3	Quilt	Qcover	16/03/2023	35	54	43
4	Towel	Pool	2/03/2023	43	65	65
5	Bed	Bedsheet	22/03/2023	24	23	76
6	Pillow	Pilprotector	1/03/2023	34	45	87
7	Quilt	Qdouble	15/03/2023	65	43	45
8	Towel	Mat	6/03/2023	76	23	34
9	Bed	bedsheet	24/03/2023	34	45	54
10	Pillow	Pillowcover	9/03/2023	56	65	23
11	Quilt	Qcover	8/03/2023	54	23	54
12	Towel	Beach	20/03/2023	34	12	34
13	Bed	bedcover	1/03/2023	23	4	76
14	Pillow	Pilprotector	27/03/2023	54	54	44
15	Quilt	Qsingle	9/03/2023	65	555	34
16	Towel	Pool	10/03/2023	76	43	23
17	Bed	bedcover	8/03/2023	76	564	54
18	Pillow	Pillowcover	12/03/2023	35	35	65
19	Quilt	Qking	21/03/2023	47	654	76
20	Towel	Beach	12/03/2023	56	345	87

Output format-

			Weend end date/Stock Due
	Sum of On Hand	Sum of committed	4/03/2023	11/03/2023	18/03/2023	25/03/2023
Bed
Pillow
Quilt
Towel

[lbendlin]

What is your definition of week?

[learner03]

@lbendlin Monday to Sunday, So week end day will be Sunday.

[lbendlin]

see attached

[learner03]

@lbendlin Thanks. I saw your solution. But, as you have used 2 seperate visuals, I want in one visual, so that when user exports the data, it should all get expored at once. 

[lbendlin]

You and I both know that is not what Power BI is about. Tell your user to change their requirements.