Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |