Forum Discussion

MH3's avatar
MH3
Helper V
6 years ago
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 ...
Need Help
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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's avatar
MH3
Helper V
6 years ago

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!