Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello, i would like create class inside a column, to sum some product by this class, for example create a class all the 10 items from my column and give it a number or letter.
Thanks in advance
class with letter for each group of 3 numbers
| 1 | A |
| 2 | A |
| 3 | A |
| 4 | B |
| 5 | B |
| 6 | B |
| 7 | C |
| 8 | C |
| 9 | C |
| 10 | D |
| 11 | D |
| 12 | D |
| 13 | E |
| 14 | E |
| 15 | E |
| 16 | F |
| 17 | F |
| 18 | F |
| 19 | G |
| 20 | G |
| 21 | G |
Solved! Go to Solution.
Interesting. That function is not listed in the official documentation
but when you spell it out it will appear
The inofficial documentation is equally vague SAMPLEAXISWITHLOCALMINMAX – DAX Guide
This article makes a reference that may help more Chris Webb's BI Blog: DAX Machine Learning Functionality Used By The Key Influencers Visual In Power...
In fact, I want to divide in some groups a table without using an expression like a switch (A :if >10;B if > 20 and so on).
Simply create 3 class in a table with the same number of elements in each class.
I think that the function SAMPLEAXISWITHLOCALMINMAX could help me, but I have not found the right way to use it. Is it more clear ?
Interesting. That function is not listed in the official documentation
but when you spell it out it will appear
The inofficial documentation is equally vague SAMPLEAXISWITHLOCALMINMAX – DAX Guide
This article makes a reference that may help more Chris Webb's BI Blog: DAX Machine Learning Functionality Used By The Key Influencers Visual In Power...
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 11 | |
| 10 | |
| 8 |