Average based on a calcuation date

[PaolaS]

I would like to make an average based on the calculation date.
My datas:

Calculated %	Calculation date
83%	10.05.2019
80%	10.05.2019
69%	10.05.2019
82%	10.05.2019
67%	10.05.2019
82%	13.05.2019
80%	13.05.2019
75%	13.05.2019
85%	13.05.2019
90%	13.05.2019

The result must be this:

Calculated %	Average	Calculation date
83%	76%	10.05.2019
80%	76%	10.05.2019
69%	76%	10.05.2019
82%	76%	10.05.2019
67%	76%	10.05.2019
82%	82%	13.05.2019
80%	82%	13.05.2019
75%	82%	13.05.2019
85%	82%	13.05.2019
90%	82%	13.05.2019

Thank you for your help!

[AlB · Accepted solution]

Hi @PaolaS,

You can create a calculated column in your table:

Average_Col =
CALCULATE (
    AVERAGE ( Table1[Calculated %] ),
    ALLEXCEPT ( Table1, Table1[Calculation date] )
)