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

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!

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

       

      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's avatar
        v-kelly-msft
        Community Support
        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!