Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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!
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])
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
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |