Forum Discussion
Stopping Line Graph to current month
- 6 years ago
Anonymous
Apologies for that...The variables aren't what you need.
Do you have a YearMonth column in your Calendar Table? (if not, please add one using the "following" DAX:
YearMonth = Calendar[Year] *100 + Calendar[Month Number]
and format it as a whole number.
For illustration purposes, I'm using a dummy model, so please adapt to yours:
Cumulative measure (no need to change yours):
Cumulative Forecast = CALCULATE([Sum of Forecast]; FILTER(ALL('Calendar Table'); 'Calendar Table'[date] <= MAX('Calendar Table'[date])))Now you can use the following measure to cut the values off at the current month:
Cut off Forecast = VAR calc = FORMAT(YEAR(TODAY()) *100 + MONTH(TODAY()); "0000") Return IF(MAX('Calendar Table'[YearMonth]) <= calc; [Cumulative Forecast]; BLANK())
Hi PaulDBrown ,
Could you help show me the pbxi file?
I have exact same need ,
cutting off running total, until todays date.
However I tried your suggestion, it does not work. (The measure shows just blank , instead of cut off).
I will create a new ticket , and invite you for answer.
Hope it is Ok!
Thanks 🙂
Anonymous
No problem! either post or send me a PM