Forum Discussion
Moving average measure with sum
Hello I am new to this forum and calculated formulas in general - so bear with me if the question is 'too easy' :) I have a simple data set like this example "FRUIT": DATE ITEM COUNT...
Give it a try...
Moving Average = CALCULATE(AVERAGE(Table2[COUNT]),ALLEXCEPT(Table2,Table2[Date]))