Hi Leo,
I looked at your formulas, above, and your clarification. And have set up an overview in Excel how I understand the calculation should be made per month (see attached Excel).
- If you want to calculate the forecast per month, maybe the second version is an option (easy to calculate) ? Please let me know your thoughts.
Setup calculation Forecast Value Measure.xlsx (11.6 KB)
- Another question : with the forecasting, is it sufficient to report per month ? (Not per day?). Formulas like DATEADD(DateT[Date],-1,MONTH) for the previous month gives the daily amount of the previous month, if reported on a daily base, and the monthly amount if reported on a monthly base, which (may) change the intended average calculations.
Kind regards, Delta Select