Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
Trying to show a cumulative sum of orders based on Dates (displayed with WeekNum)
My table Currently looks like this ;
Week Num | Count |
1 | 1 |
2 | 4 |
3 | 3 |
4 | 7 |
My Future State is
Week Num | Sum |
1 | 1 |
2 | 5 |
3 | 8 |
Thanks!
@Anonymous ,
A new column
sumx(filter(Table, [Week Num] <= earlier([Week Num])),[count])
A new measure
sumx(filter(allselected(Table), Table[Week Num] <= max(Table[Week Num])),Table[count])
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
8 | |
7 |