dax _ moving average
1 Topic
Moving Average with fixed first date
Dear Community, How can I count a kind of a moving averge that works likes this: First date is fixed and the average is counted on adding every next date's data as it procceeds. For example: I have Date A B C D E 1 ID Date Weights Box weight Weight / pack 2 1111 01/01/2022 4 25 13 3 1112 02/01/2022 4.5 23 12.7 4 1125 05/01/2022 4.4 25.6 13.1 5 1143 06/01/2022 4.2 25.2 12.4 7 1156 09/01/2022 4.5 23.8 13.3 So, now the aevarge is counted like this in excel: IF(AND(A1<>"",C1<>"-"),ROUND(AVERAGE($E$1:E1),1),"-") . The part that confuses me is that fixing the first value and calculateing the average of that fixed value plus every next one as it goes. Thank you for your help!Solved353Views0likes1Comment