Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I’ve a following problem:
There’s a table with the following columns:
Date | Value |
2018.06.25 | 12 |
2018.06.26 | 12 |
2018.06.27 | 12 |
2018.06.28 | 4 |
2018.06.28 | 8 |
2018.06.29 | 1 |
2018.06.29 | 8 |
How can I add a column, that sums the values by the actual date in the row, like this?
Date | Value | SumValue |
2018.06.25 | 12 | 12 |
2018.06.26 | 12 | 24 |
2018.06.27 | 12 | 36 |
2018.06.28 | 4 | 40 |
2018.06.28 | 8 | 48 |
2018.06.29 | 1 | 49 |
2018.06.29 | 8 | 57 |
Thanks for your suggestions in advance!
Zoltán
Solved! Go to Solution.
Hi @ZoltanFut
Try this for your new column. Note that this will yield the same result for all rows with the same date, since I see there are duplicates.
CumulativeSumValue = CALCULATE ( SUM ( Table1[Value] ), FILTER ( Table1, Table1[Date] <= EARLIER ( Table1[Date] ) ) )
Hi @ZoltanFut
Try this for your new column. Note that this will yield the same result for all rows with the same date, since I see there are duplicates.
CumulativeSumValue = CALCULATE ( SUM ( Table1[Value] ), FILTER ( Table1, Table1[Date] <= EARLIER ( Table1[Date] ) ) )
Hi AlB,
thanks for the solution, and the idea, I can work toward on this 🙂
thanks
Zoltán
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |