how to use powerpivot measure function to count total Deposit AVERAGE?

[Oscarr]

hi,

how to use powerpivot measure function to count total Deposit AVERAGE?

Thanks

 

[GraH - Guido]

According to me you can't really do that the way you present it.
Or you have a second pivot that gives to the average, either you'd have an average that is repeated each month. I'm sure that's not the best readable format.

 

[Oscarr]

According to me you can't really do that the way you present it.
Or you have a second pivot that gives to the average, either you'd have an average that is repeated each month. I'm sure that's not the best readable format.
View attachment 66715

hi @GraH - Guido

can give me that sample file?

Thanks