Forum Discussion

jeyare's avatar
jeyare
Icon for Helper II rankHelper II
4 years ago
Solved

Average calculate within table

Hi there,   I have aggregated Table where I need to calculate AVERAGE for a Length of Employment in days (LoE) from: StartDate (this value is not empty in the column) EndDate (this value is empty...
  • amitchandak's avatar
    amitchandak
    4 years ago

    jeyare , Based on what I got

     

    A new column = AverageX(filter(Table, [PositionName ] = earlier([PositionName ])  && [Department ] = earlier([Department ])  && [Centre ] = earlier([Centre ]) ), [LOE])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jeyare , Based on what I got

 

A new column = AverageX(filter(Table, [PositionName ] = earlier([PositionName ])  && [Department ] = earlier([Department ])  && [Centre ] = earlier([Centre ]) ), [LOE])