MH3Helper V6 years agoSolvedForecast 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 ...Show Morev-kelly-msft to MH36 years agoHi 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,KellyDid I answer your question? Mark my post as a solution!
v-kelly-msft to MH36 years agoHi 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,KellyDid I answer your question? Mark my post as a solution!
v-kelly-msft to MH36 years agoHi 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,KellyDid I answer your question? Mark my post as a solution!
v-kelly-msftCommunity Support6 years agoHi 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,KellyDid I answer your question? Mark my post as a solution!
MH3Helper V to v-kelly-msft6 years agov-kelly-msft Thanks for your solution, I have used this function of NextMonth.
Related contentForecasting with DAXNext 3 month forecast by monthForecast Future MonthsForecastingClosing Forecasting for Year and Month
