Forum Discussion
How create class inside a column
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 |
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 BI (crossjoin.co.uk)
3 Replies
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
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 BI (crossjoin.co.uk)
