Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Goodday,
I need a calculation which sums up the total of a certain column.
For example the column 'Aantal HP gerealiseerd' has a number of HP's per week but i need a column that shows the cumulative per week.
i think it's pretty simple but im not sure how to do it
For example
2018-35 186
2018-36 418 (186 + 232)
2018-37 727 (418 + 309)
2018-38 etc
Solved! Go to Solution.
Modeling -> New measure, and copy the code:
Cumulatieve HP gerealiseerd =
CALCULATE ([Totaal aantal HP];
FILTER(
ALL(Forecast);
'Forecast'[Week]<=MAX(Forecast[Week])
)
It will work as a line or bar graph. Put a Date dimension on the Axis and your newly created measure to Values.
For me it looks like this:
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |