Forum Discussion
DAX Future Forecast Including Full Current Month
Hello! I am trying to display a future forecast cost for all future months including the full current month. Here is the closest I've found thus far: Future_Forecast = VAR LastActualsDate = CAL...
Try this
These two measure will be used for the target calculation
Sale sum = Sum('table'[sale])
Condition = CALCULATE((Table[sale sum]*(10/100)+Table[Sale Sum]))
// You can add percentage of your own choice here it is 10 percent //Target value = CALCULATE([Condition],DATEADD(date_dim[Date],-1,YEAR),ALL(date_dim[Date],date_dim[Year],date_dim[Quarters],date_dim[Week No] ))+0Result should be like this
Try this
These two measure will be used for the target calculation
Sale sum = Sum('table'[sale])
Condition = CALCULATE((Table[sale sum]*(10/100)+Table[Sale Sum]))
// You can add percentage of your own choice here it is 10 percent //
Target value = CALCULATE([Condition],DATEADD(date_dim[Date],-1,YEAR),ALL(date_dim[Date],date_dim[Year],date_dim[Quarters],date_dim[Week No] ))+0
Result should be like this