Forum Discussion

1001's avatar
1001
Icon for Resolver II rankResolver II
2 years ago
Solved

A DAX Calculation Question

Hi All, I have a column of values (production forecast) and a date table with the column, Week Begining applied to the filters Pane.   I've filtered out any zero values and have Average Forecast = ...
  • amustafa's avatar
    amustafa
    2 years ago

    You can try these 2 new measures

    Total Forecast by Week = CALCULATE(SUM(Budget[Forecast]), ALLEXCEPT(Budget, Date[Week Beginning]))

    Average Weekly Volume = AVERAGEX(VALUES(Date[Week Beginning]), [Total Forecast by Week])

amustafa's avatar
amustafa
Icon for Solution Sage rankSolution Sage
2 years ago

You can try these 2 new measures

Total Forecast by Week = CALCULATE(SUM(Budget[Forecast]), ALLEXCEPT(Budget, Date[Week Beginning]))

Average Weekly Volume = AVERAGEX(VALUES(Date[Week Beginning]), [Total Forecast by Week])