Group Average

[AllanBerces]

Hi good day,

Can anyone help me on how can i get the average on my table below.

OUTPUT

Thank you

[Ashish_Mathur]

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.

[Selva-Salimi · Accepted solution]

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.

[AllanBerces]

HI @Selva-Salimi thank you for the reply.