Forum Discussion
lherbert501
Post Prodigy
Post Prodigy6 Month Average Overall without Slicer
Hi there, I have a measure that calculates the rolling average over 6 months which works great as below. In my dataset it only contains 6 months so it will cut out e.g. February when...
Managed to do this with the ALL function 🙂
lherbert501Post Prodigy
Post Prodigyhi amitchandak
Thanks so much for the reply.
The new measure that you have wrote with an extra date table gives the same result as the rolling average below.
The column in yellow is what I'm aiming for if its possible. 6 Month overall average regardless of slicer change?
Thanks
Liam
lherbert501Post Prodigy
Post ProdigyManaged to do this with the ALL function 🙂