Forum Discussion

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....

Need Help

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] )
)

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] )
)