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.
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):
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |