Forum Discussion

PaolaS's avatar
PaolaS
New Member
7 years ago
Solved

Average based on a calcuation date

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 %AverageCalculation 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!

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi PaolaS,

    You can create a calculated column in your table:

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

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi PaolaS,

    You can create a calculated column in your table:

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