Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyGroup Average
Hi good day, Can anyone help me on how can i get the average on my table below. OUTPUT Thank you
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.
Ashish_Mathur
Super User
Super UserHi,
Just in case you want a measure, try this
Measure = averagex(all(Data[Trade]),[Completed])
I have assumed that Completed is a measure which you have written.