Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |