Total up to the end of week matrix

Ejykso — Mon, 20 Feb 2023 18:48:07 GMT

Hi All,
I'll appreciate it if someone can help with a way to resolve this issue.
I'm to present my data in this format:

Up to End of Week	19.2023		12.2.2023		Variance
Period	Vol	Net	Vol	Net	Vol	Net
1-7 Days	20	2000	10	1000	10	1000
8-14 Days	20	1000	10	2000	10	-1000
15-21 Days	10	4000	20	3000	-10	1000
21days +	55	3000	30	4000	25	-1000
Total	105	10000	70	10000	35	0

But my data came is showing as this:

End of Week	19.2.2023		12.2.2023		05.2.2023			29/01/2023	Total
Period	Vol	Net	Vol	Net	Vol	Net	Vol	Net	Vol	Net
1-7 Days	20	2000	10	1000					30	3000
8-14 Days			10	2000			20	1000	30	3000
15-21 Days					20	3000	10	4000	30	7000
21days +			30	4000	55	3000			85	7000
Total	105	10000	50	7000					175	20000

Basically, what I intend to achieve is to show the total Vol and Net up to the end of the week which table 1 is doing, and then compare it with the total up to the end of the previous week.

My current method is splitting the data into different end of weekdays as seen in table 2 simply because of the end-of-week column that I'm using from my date table then showing the total at the end. I want this total which occurs at the end to be showing under 19:02:2023. My days period is calculated from the difference between the date of sale and today using a switch () so the longer the difference, the figures would start falling into different end of weeks days which I don't want.

topic Total up to the end of week matrix in DAX Commands and Tips

Total up to the end of week matrix