Forum Discussion
Matrix view with weekend going across
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,...
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
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
