Forum Discussion

Oomsen's avatar
Oomsen
Helper III
6 years ago
Solved

Salesforecast

Hello, i'm looking for a measure to forecast my sales.  I would like to sum the actual sales by month until the current month. For futher months i would like to have a average of the last 6 months....
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Oomsen 

    I think it could not achieve in dax in power bi, this since it will calculate by its own value, it is very difficult to achieve.

     

    Regards,

    Lin

Oomsen's avatar
Oomsen
Helper III
6 years ago

amitchandak , thanks for your respons.

My current measure is 

fomzet = IF(MONTH(MIN(Dimdate[MaandVanJaar]))<=MONTH(TODAY()),
CALCULATE(SUM(Transacties[amountdc])*-1,'Grootboekclassificaties'[parent_description]IN{"Opbrengsten"},ALL('Grootboekclassificaties'[parent_code_attr])),
CALCULATE(SUM(Transacties[amountdc])*-1,'Grootboekclassificaties'[parent_description]IN{"Opbrengsten"},ALL('Grootboekclassificaties'[parent_code_attr]),DATESINPERIOD(Dimdate[Datum],MAX(Dimdate[Datum]),-6,MONTH))/6)
some parts are in dutch, sorry for that.
the current result is that the past and current month give the correct value but the future months are blank.
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Oomsen 

Please make sure use Date field from Dimdate in the visual.

 

If you still have the problem, please share your sample pbix file for us have a test

 

Regards,

Lin

  • Oomsen's avatar
    Oomsen
    Helper III
    6 years ago

    v-lili6-msft amitchandak  it works. 

    For future months it is using 0 for calculating the average instead of the amount in the measure.

    Example:

    jan feb mrt apr may  jun  jul  aug  sep  oct  nov  dec

    10  10  20   30   40    50   27  25    23

    Expected:

    jan feb mrt apr may  jun  jul  aug  sep  oct  nov  dec

    10  10  20   30   40    50   27  31    33    

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      hi  Oomsen 

      I think it could not achieve in dax in power bi, this since it will calculate by its own value, it is very difficult to achieve.

       

      Regards,

      Lin