12-12-2018 01:05 AM
I have made a measure that accumulates over week_number:
acc actual 2018 = calculate(sum('actuals 2017[2018 Actuals]); Filter(Allselcted(Actuals 2017); Actuals 2017[weekno] <= max(Actuals 2017[weekno])))
but when i plot the measure with weekno i get a plateau that I dont want, since it is still some weeks without data for 2018. I want the graph to stop at week 49, so that i instead of have a plateau can ha a prediction for what's left of the year.
I tried to make a measure that returns blank when the weekno we are currently in are higher than the weekno i am trying to accumulate.
chec = IF( CALCULATE ( MAX ( Actuals 2017[weekno]); ALL(Actuals 2017[weekno])) < WEEKNUM(TODAY()) ; [acc actual 2018] ; BLANK())
But when i do this the measure refuses to be plotted with weekno. I can't see anything..
Can someone help??
12-12-2018 10:43 PM
I'd like some sample data to help us clear your table structure and test to coding formula.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For learning resources/Release notes, please visit: | |