Forum Discussion
Solved
Forecast Next Month
I have Forecast Sales from Current Month till the End of the year Like its 20/March/2020, I have Forecast from 20 March and so on, I want to see the Total of Next Month in a Card Value ...
Try something like this
measure =
var _max = maxx(date,date[Date])
return
if(format(today(),"YYYYMM") >=format(_max,"YYYYMM"), [revenue], [forecast])
or
measure =
var _max = maxx(date,date[Date])
return
if(format(today(),"YYYYMM") >=format(max(date[Date]),"YYYYMM"), [revenue], [forecast])
My Forecast Room Revenue Measure is :
Which is displaying forecast for all the dates, from the current month date.
FC Room Revenue = If( [FC ADR]=BLANK(),
BLANK(), [FC ADR]*[FC Occupied Room])
My Forecast Room Revenue Next Month Measure is:
want to display a Card Value, Like if current month is march, then it should April, and then April comes, then it will show May's Forecast.
forecast NextMonth = CALCULATE(
[FC Room Revenue],
FILTER(DimCalendar, MONTH(DimCalendar[Date]+1))
)This Measure is Broken, as you can see in the ScreenShot amitchandak