Forecast Next Month

[MH3]

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 and it should change according to the context of Current Month from the Forecast

for Example:  I have Sales Forecast for the Month of March, April, .... and so on

I need a single Sum of April Forecast in context of Current Month which is March.

Like Current Month is March, So, (April Sale Forecast ex ; 5000), and when the Current Month changes it should show May Forecast respectively.

Kindly Help 

@amitchandak 

[MH3]

@v-kelly-msft 

How can I calculate forecast for the Next Season?

as I have Two Seasons in my Date Table in which

27 Weeks is of Summer Season and the other 27 Weeks is of Winter Season in each Year,

I want to calculate the Next Season Forecast, how can I achieve this I haven't found the function for Next Season though.

Help!

[amitchandak]

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])

[MH3]

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  

[v-kelly-msft · Accepted solution]

Hi @MH3 ,

Modify your measure as below:

forecast NextMonth = CALCULATE(
    [FC Room Revenue],
    NEXTMONTH(DimCalendar[Date]))
)

I create sample data you can refer to,pls click here.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[MH3]

@v-kelly-msft 

Thanks for your solution,

I have used this function of NextMonth.