sum calculatin using filter and all functions

[polinab]

Hi,

Having table below I need calculate total sum after certain time id (10/15/2023 in example) and present it in each cell as following.

using filter(Time ID > 10/15/2023) and then all(Time ID) doesnt work 

Please help

Time ID	COMPLETED_PER_WEEK	Completed Effort Sum using filter	Need to present
7/30/2023	3.43
8/6/2023	9.63
8/13/2023	1.15
8/20/2023	2.23
8/27/2023	0.5
9/3/2023	5.48
9/10/2023	0.63
9/17/2023	0
9/24/2023	2.28
10/1/2023	2.42
10/8/2023	3.29
10/15/2023	1.36	1.36	24.24
10/22/2023	8.245	8.245	24.24
10/29/2023	7.69	7.69	24.24
11/5/2023	5.79	5.79	24.24
11/12/2023	0.955	0.955	24.24
11/14/2023	0.2	0.2	24.24
Total	55.28	24.24

[amitchandak · Accepted solution]

@polinab , Based on what I got

Assume Completed  is column we need sum

Calculate(Sum(Table[Completed]) , filter(allselected(Table), Table[Time] > Date(2023,11,15) ) )

[polinab]

Thank you Amit,

allselected  worked for me