Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PowerBiNoob
Frequent Visitor

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

 

SampleValueTimeSampledWhatWeek
37.2402343813/07/2017Last  Week
7.13085937513/07/2017Last  Week
50.1259765613/07/2017Last  Week
20.2041015613/07/2017Last  Week
17.398437513/07/2017Last  Week
3.62207031313/07/2017Last  Week
5.8632812518/07/2017Current Week
311.057617218/07/2017Current Week
281.651367218/07/2017Current Week
52.5800781318/07/2017Current Week
63.4306640618/07/2017Current Week
7.90722656318/07/2017Current Week
219.142578118/07/2017Current Week
1 ACCEPTED 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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Phil_Seamark
Employee
Employee

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.

 

WhatWeek.jpg


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors