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

 

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 

     

    Thanks for your solution,

     

    I have used this function of NextMonth.