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?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 9 | |
| 8 |