Moving Average with fixed first date

[Anonymous]

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!

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the following measure:

Moving Average = 
VAR FirstID = FIRSTNONBLANKVALUE ( 'Table'[Date], MAX ( 'Table'[ID] ) )
VAR firstWeight = FIRSTNONBLANKVALUE ( 'Table'[Date], SUM ( 'Table'[Weights] ) )
VAR Ave =
    CALCULATE (
        AVERAGE ( 'Table'[Weight / pack] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
    )
RETURN
    IF ( AND ( FirstID <> BLANK (), ISNUMBER ( firstWeight ) ), Ave, "-" )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.