Forum Discussion
Avg on different values in same column
Hey,
I have a Table which contains the following columns, I would like to get the average of the "SampleValue" for each of the "WhatWeek" - example (avg 22.6 for Last Week , avg 134.5 for Current Week) ? Regards
| SampleValue | TimeSampled | WhatWeek |
| 37.24023438 | 13/07/2017 | Last Week |
| 7.130859375 | 13/07/2017 | Last Week |
| 50.12597656 | 13/07/2017 | Last Week |
| 20.20410156 | 13/07/2017 | Last Week |
| 17.3984375 | 13/07/2017 | Last Week |
| 3.622070313 | 13/07/2017 | Last Week |
| 5.86328125 | 18/07/2017 | Current Week |
| 311.0576172 | 18/07/2017 | Current Week |
| 281.6513672 | 18/07/2017 | Current Week |
| 52.58007813 | 18/07/2017 | Current Week |
| 63.43066406 | 18/07/2017 | Current Week |
| 7.907226563 | 18/07/2017 | Current Week |
| 219.1425781 | 18/07/2017 | Current Week |
Hi PowerBiNoob
To do what you want, just create some calculated measures. You can start with a pretty easy measure like :
Average of SampleValue = AVERAGE('Table1'[SampleValue])And then drag this to your visual. You can then create additional measures for your previous week, and difference metrics
3 Replies
Hi PowerBiNoob
If you drag your 'WhatWeek' to the report canvas and change your visual to be Table or Matrix. Then drag the SampleValue column to the same visual, the default behaviour will be SUM. Then click on the SampleValue field in the values area and change the default aggregation to Average. This will work the same for other visuals.
Thanks for the response , I need to use the values in a KPI visual to get the avg diff between current and last week, but doing what you suggest works fine for table display...thank you again
Hi PowerBiNoob
To do what you want, just create some calculated measures. You can start with a pretty easy measure like :
Average of SampleValue = AVERAGE('Table1'[SampleValue])And then drag this to your visual. You can then create additional measures for your previous week, and difference metrics
