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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |