Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
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):
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
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):
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |