The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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):
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |