I have every business date and a value, sum each value by week

[wonka1234]

Hi,

I dont have the week, I only have business date. 

How can I sum each business date for a given week? I need every monday.

expected output - 

date	Weekend	placeholder		newly added --->	new placeholder	week
1/2/2023	Monday	1			5	1/2/2023
1/3/2023	Tuesday	1			5	1/2/2023
1/4/2023	Wednesday	1			5	1/2/2023
1/5/2023	Thursday	1			5	1/2/2023
1/6/2023	Friday	1			5	1/2/2023
1/9/2023	Monday	0			0	1/9/2023
1/10/2023	Tuesday	0			0	1/9/2023
1/11/2023	Wednesday	0			0	1/9/2023
1/12/2023	Thursday	0			0	1/9/2023
1/13/2023	Friday	0			0	1/9/2023

[smoosh]

@wonka1234 no particular reason, data would also get filtered in the join. 

[DanielG]

@wonka1234 -- glad you found a solution.  Based upon @smoosh comment above, I'd remove the filter all together as it isn't needed.  It is good practice to make things as efficient as possible especially as you build bigger and more complex processes.  

Good luck on your journey.