Forum Discussion
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....
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
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
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