Forum Discussion
Help Needed - is it possible to display a calculated rolling average of combined values?
Hi, I am using PowerBI to model weekly figures of services delivered. These services are split into categories. I have reviewed previous posts on the community and found a useful measure to calcu...
v-yalanwu-msft
Community Support
Community SupportHi, BenDC ;
You could try it.
Rolling Average2 =
AVERAGEX(
FILTER( 'Reporting - Devices Weekly',
'Reporting - Devices Weekly'[Week Start] <= MAX( 'Reporting - Devices Weekly'[Week Start] ) ),
'Reporting - Devices Weekly'[Quantity] )The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yalanwu-msft,
Thank you very much for looking at this. It's the first time I've been able to display a rolling average with multiple categories selected, so it is a great step forward, however, it is not calculating the average based on the combined weekly total quantities in the selection.
For example, I've filtered to 2 categories over 4 weeks.
| Week Start Date | 24 December 2021 | 31 December 2021 | 07 January 2022 | 14 January 2022 | Totals | |||||
| Category | Quantity | Average | Quantity | Average | Quantity | Average | Quantity | Average | Quantity | Average |
| Total Quantity | 86 | 86 | 48 | 67 | 34 | 56 | 17 | 46.25 | 185 | 46.25 |
| Ascom Myco3 - Order | 86 | 86 | 28 | 57 | 22 | 45.33 | 17 | 38.25 | 153 | 38.25 |
| Samsung Xcover5 - Order | 20 | 20 | 12 | 16 | 32 | 16 |
Using this formula, it produces an overall average of 30.83:
I haven't been able to work out how this figure is calculated.