Forum Discussion
Solved
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 Curren...
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
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