Forum Discussion
Solved
HELP !! simple calculation ?!
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 cumulat...
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:
Anonymous
How ?
Besides i need this data for a bar or a line graph so does that still work if i use a measure ?
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: