Forum Discussion
Group 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.
3 Replies
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.
HI Selva-Salimi thank you for the reply.
Hi,
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.
