cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## min max and average

Hi

I am new to this and struggling with a measure.

I need to know the minimum sales value of each item number (and maximum); plus the average sales value by each item number.  Can someone please help? TIA

 Item Total Sales 10 33750 7 20850 14 50080 11 36300 14 61750 8 32000 8 27300 9 31600 14 59900 14 57700 8 26000 14 62750 9 28050 10 35550 9 31050 13 43700 9 30350
1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: min max and average

It's not that hard. And, what's important, to perform this analysis you don't need to write a single line of code :-)

See the video I've just produced to show how this can be done (no sound):

2 REPLIES 2
Member

## Re: min max and average

It's not that hard. And, what's important, to perform this analysis you don't need to write a single line of code :-)

See the video I've just produced to show how this can be done (no sound):

Community Support Team

## Re: min max and average

HI @Kpaffey,

The simple way is create a table visual with multiple total sales columns and switch its summary mode to show different result:

Notice: you should setting the item to 'don't summarize' before these operations.

In addition, you can also use summarize function to summary the records:

`Summary table = SUMMARIZE(Sheet4,[Item],"Min",MIN(Sheet4[Total Sales]),"Max",MAX(Sheet4[Total Sales]),"Average",AVERAGE(Sheet4[Total Sales])) `

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 173 members 2,278 guests
Recent signins: