Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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 , 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) ) )
Thank you Amit,
allselected worked for me
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |