Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Group Average

Hi good day, Can anyone help me on how can i get the average on my table below. OUTPUT Thank you
  • Selva-Salimi's avatar
    1 year ago

    Hi AllanBerces 

     

    you can write a column as follows:

     

    calculate (average (completed) , filter (table , [job#] = earlier ([job#]))

     

    If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.