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:
It sounds like you need a semi-additive measure.
You would need a date dimension table, but then a formula like:
Total : =
CALCULATE (
[FIELD],
LASTDATE ( 'Date' [Date] )
)
I have a 'date' table so that is ok but im not sure what to fill in at the [Field] part of the calculation.
Can you tell me ? i tried a few things but it's doesn't work just yet
Cumulatieve HP gerealiseerd=
CALCULATE (
[FIELD];
LASTDATE ( 'Date'[Date] )
)
