Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
How do we find the cumulative sum, when we have repeating rows of data for a dimension?
eg:
I have the following data - date, country and cases.
01/01/20 US 100
01/01/20 UAE 10
01/01/20 FR 20
02/01/20 US 100
02/01/20 UAE 10
02/01/20 FR 20
When I do a cumulative sum of cases, I get the sum of the total cases for 01/01/20 repeated for the number of rows (130*3) and the cumulative sum is all wrong.
This is the calculated column being used.
Solved! Go to Solution.
please try this
Cumulative = CALCULATE(sum(Summary[Cases]), FILTER(Summary),Summary[date] <= EARLIER(Summary[date])&&country =earlier(country))
Proud to be a Super User!
please try this
Cumulative = CALCULATE(sum(Summary[Cases]), FILTER(Summary),Summary[date] <= EARLIER(Summary[date])&&country =earlier(country))
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |