Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?? 🙂
Hi @AneZ,
I'd like some sample data to help us clear your table structure and test to coding formula.
Regards,
Xiaoxin Sheng
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |