Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help in forecasting for MTD

Hi there, been stuck with this for a couple of days now and would like to know how to solve it.    I need to determine the forecast of sales for a particular month based on the average MTD sales. S...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , try

    new measure =

    Var  _avg = CALCULATE(AverageX(values('DAte'[Date]),CALCULATE(SUM(Sales[Sales Amount])),DATESMTD('Date'[Date]))

    return

    _avg * Day(eomonth(Max('Date'[Date]),0))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you very much amitchandak, worked as mentioned.